Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
A program that you write and that Oracle OLAP checks for by name when an AW ATTACH read-only statement executes. Depending on the value returned by the program, Oracle OLAP executes the code within the program after attaching the analytic workspace. Depending on the statements in the permit_read
program the user is granted or denied access to specific objects or sets of object values. Within permit_read
program, you can specify PERMIT commands that grant or restrict access to individual workspace objects. All of the objects referred to in a given permit_read
must exist in the same analytic workspace.
See also:
"Startup Programs"Return Value
BOOLEAN
TRUE
when Oracle OLAP has successfully set up and attached the analytic workspace; or FALSE
when it has not or when the permit_read
program has thrown an exception
Note:
You are encouraged to use the normal return values rather than relying on exceptions to create a return value ofFALSE
.Syntax
To define a program with the name PERMIT_READ
use the syntax shown in DEFINE PROGRAM. Code the actual program as a user-defined function with the following argument.
PERMIT_READ (password)
Arguments
See AW ATTACH for an explanation of password. When a user specifies a password when attaching the analytic workspace, then the password is passed as an argument to the program for processing.
Examples
To see the order in which permission programs are executed when an analytic workspace is attached, see Example 10-14, "Startup Programs".