Summary of OLAP_API_SESSION_INIT Subprograms

The following table describes the subprograms provided in OLAP_API_SESSION_INIT.

---

ADD_ALTER_SESSION Procedure

This procedure specifies an ALTER SESSION parameter for OLAP API users with a particular database role. It adds a row to the OLAP$ALTER_SESSION table.

Syntax

ADD_ALTER_SESSION (
     role_name           IN     VARCHAR2,
     session_parameter   IN     VARCHAR2);

Parameters

The role_name and session_parameter are added as a row in OLAP$ALTER_SESSION.

Example

The following call inserts a row in OLAP$ALTER_SESSION that turns on query rewrite for users with the OLAP_USER role.

call olap_api_session_init.add_alter_session(
     'OLAP_USER', 'SET QUERY_REWRITE_ENABLED=TRUE');

The ALL_OLAP_ALTER_SESSION view now contains the following row.

ROLE                CLAUSE TEST
-----------------   ----------------------------------------------------
OLAP_USER            ALTER SESSION SET QUERY_REWRITE_ENABLED=TRUE

---

CLEAN_ALTER_SESSION Procedure

This procedure removes all ALTER SESSION parameters for any role that is not currently defined in the database. It removes all orphaned rows in the OLAP$ALTER_SESSION table for those roles.

Syntax

CLEAN_ALTER_SESSION ();

Examples

The following call deletes all orphaned rows.

call olap_api_session_init.clean_alter_session();

---

DELETE_ALTER_SESSION Procedure

This procedure removes a previously defined ALTER SESSION parameter for OLAP API users with a particular database role. It deletes a row from the OLAP$ALTER_SESSION table.

Syntax

DELETE_ALTER_SESSION (
     role_name           IN     VARCHAR2,
     session_parameter   IN     VARCHAR2);

Parameters

The role_name and session_parameter together uniquely identify a row in OLAP$ALTER_SESSION.

Examples

The following call deletes a row in OLAP$ALTER_SESSION that contains a value of OLAP_USER in the first column and QUERY_REWRITE_ENABLED=TRUE in the second column.

call olap_api_session_init.delete_alter_session(
     'OLAP_USER', 'SET QUERY_REWRITE_ENABLED=TRUE');