Previous
Previous
 
Next
Next

Permission Programs

Permission programs are programs that you write that give permission to users to access workspace data. When a user first attaches an analytic workspace, Oracle OLAP checks to see if a permission program that is appropriate for the attachment mode exists.


Note:

When you reattach an attached workspace, Oracle OLAP does not look for and execute permission programs.

The permission program for each attachment mode must have a particular name as outlined in Table: Names of Permission Programs for Different Attachment Modes.

Names of Permission Programs for Different Attachment Modes

Attachment Modes Name of Program

Read-only

PERMIT_READ


Multiwriter, Read/write

PERMIT_WRITE



When an appropriate permission program exists, Oracle OLAP executes the program. When a user specifies a password when attaching the analytic workspace, then the password is passed as an argument to the permission program for processing.


Note:

A dimension surrogate has the access permissions of its dimension. Use a PERMIT on a dimension to grant or deny permission to access the values of a dimension surrogate for that dimension.

Permission programs allow you to control two levels of access to the analytic workspace in which they reside.

To create a permission program, define a user-defined function (as described in "Creating User-Defined Functions") with a recognized name, then define the contents for the program as described in "Specifying Program Contents".