OBIEE - Privilege package

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

1 - About

A privilege package is a container for other privileges.

It corresponds to a set of permissions that applies to a particular user or application role object in the repository metadata.

The privilege package contains the information available on the:

  • Object Permissions,
  • Data Filters,
  • and Query Limits tabs

of the User/Application Role Permissions dialog in the Administration Tool.

Because privilege packages can be associated with more than one user or application role, the total number of privilege packages may not equal the total number of users and application roles.

Privilege packages are considered internal objects.

3 - Example

Example of a role myApplicationRole where the package PrivPack_4209:626221358179285 is applied. This is a part of the repository in a udml format.

DECLARE SECURITY ROLE "myApplicationRole" AS "myApplicationRole" 
        UPGRADE ID '802c2a78-106e-0000-714b-e31d00000000' 
        PRIVILEGE PACKAGE "PrivPack_4209:626221358179285"
	GUID  "myApplicationRole"
	PRIVILEGES ( READ);
DECLARE PRIVILEGE PACKAGE "PrivPack_4209:626221358179285" AS "PrivPack_4209:626221358179285" 
        UPGRADE ID '41f03050-0c5a-1000-8d06-ac1201320000'
	NONE SET "ObjPriv_1500:722321385045820"
	QUERY PRIVILEGE (
		 "QueryPriv_4204:696811379062964" ON  "otadw",
		 "QueryPriv_4204:696821379062964" ON  "otadw_audit",
		 "QueryPriv_4204:696801379062964" ON  "xml",
		 "QueryPriv_4204:696791379062964" ON  "prddw_usage_tracking" )
	FILTER CONDITION ( 
		LOGICAL TABLE "BMM"."LogicalTable" {"BMM"."LogicalTable"."LogicalColumn" = VALUEOF(NQ_SESSION."myVariableSession")}  ENABLE,
		LOGICAL TABLE "BMM"."LogicalTable2" {"BMM"."LogicalTable"."LogicalColumn" = VALUEOF(NQ_SESSION."myVariableSession")}  ENABLE)
	PRIVILEGES ( READ);
Advertising

4 - Documentation / Reference