Configuring security for BIRT reporting

OpenText recommends that you create a separate, read-only database account specifically for BIRT reporting.

To limit write access to tables and views in the database:

1. Create a database user account to use exclusively for BIRT reporting and provide minimum permission required to generate reports.

2. For the new user account, enable read-only access the database tables and views listed in the following table.

   Tables
   attr	issuecache	reportexecblob
   auditattachment	measurement	reportexecparam
   auditcomment	measurementhistory	ruledescription
   catpackexternalcategory	metadef	savedreport
   catpackexternallist	metadef_t	scan
   catpacklookup	metaoption	scan_rulepack
   datablob	metaoption_t	seedhistory
   documentinfo	metavalue	sourcefile
   eventlogentry	metavalueselection	snapshot
   f360global	project	userpreference
   filterset	projecttemplate	variable
   folder	projectversion	variablehistory
   foldercountcache	projectversiondependency
   Views
   attrlookupview	defaultissueview	ruleview
   auditvalueview	metadefview	view_standards
   baseissueview	metaoptionview

3. Sign in to Application Security as an Administrator.
4. On the header, select Administration.

5. On the navigation pane, expand Configuration, and then click BIRT Reports.

6. In the DB username and DB password boxes, type the credentials for the database account that has read-only database access.

7. To test that the database user account has access to the database, click VALIDATE CONNECTION.
8. Click SAVE.

See Also

Allocating memory for report generation

Setting report generation timeout