Database Layer

Objects specific to Oracle Business Intelligence Publisher Reporting are present in a separate schema created during the installation of the Oracle Argus Safety database. This schema only has a limited set of objects and access privileges. Table 6-1 illustrates these objects and privileges.

Table 6-1 Objects and Access Privileges

Element	Description
Tables	Global Temporary tables populate the report. RM tables persist data for Oracle Argus Mart OBIEE dashboards. Configuration tables store report parameter prompts and case series data.
Packages	There are 3 packages: The main package loads the temp table data. The utility package holds the commonly used functions while loading the temp table data. The user exit package customizes the loaded temp table data. None of the packages are wrapped.
Views	Used for grouping and accessed in the Oracle Business Intelligence Publisher data model.
Access Grants	Oracle Business Intelligence Publisher has read-only access to the following objects in the Oracle Argus Safety application schema: List and configuration tables Case series tables Case tables Common packages such as gss, gss_util, gss_periodic, p_initialize_access and gss_wnds It has INSERT and SELECT access to: CMN_REG_REPORTS PER_RPT_QUEUE PER_RPT_STATUS CMN_PER_SUB_CHILD CASE_REG_REPORTS Report output tables
Invoker Rights	BIP packages are created with Invoker rights with CURRENT_USER as the AUTHID.
Enterprise Security	The new schema implements the Oracle Argus Safety enterprise security features. For data selection, call gss_util.set_context (uname, enterprise).

• Configuration Extensibility
  
• Extending with User Exits
  
• Extending Global Temporary Tables
  
• Extending using Custom Objects
  
• Adding or Modifying a View
  
• Adding a Column to the Existing Table