Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The following table describes the subprograms provided in OLAP_API_SESSION_INIT
.
Table C-2 OLAP_API_SESSION_INIT Subprograms
Subprogram | Description |
---|---|
Specifies an |
|
Removes orphaned data, that is, any |
|
Removes a previously defined |
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.
ADD_ALTER_SESSION ( role_name IN VARCHAR2, session_parameter IN VARCHAR2);
The role_name
and session_parameter
are added as a row in OLAP$ALTER_SESSION
.
Table C-3 ADD_ALTER_SESSION Procedure Parameters
Parameter | Description |
---|---|
|
The name of a valid role in the database. Required. |
|
A parameter that can be set with a SQL |
The following example inserts a row in OLAP$ALTER_SESSION
that turns on query rewrite for users with the OLAP_DBA
role.
EXECUTE olap_api_session_init.add_alter_session('OLAP_DBA', 'SET QUERY_REWRITE_ENABLED=TRUE'); Row inserted SELECT * FROM all_olap_alter_session WHERE role='OLAP_DBA'; ROLE CLAUSE_TEXT ------------ ------------------------------------------------------------ OLAP_DBA ALTER SESSION SET QUERY_REWRITE_ENABLED=TRUE
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.
CLEAN_ALTER_SESSION ();
The following example deletes all orphaned rows.
EXECUTE olap_api_session_init.clean_alter_session();
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.
DELETE_ALTER_SESSION ( role_name IN VARCHAR2, session_parameter IN VARCHAR2);
The role_name
and session_parameter
together uniquely identify a row in OLAP$ALTER_SESSION
.
Table C-4 DELETE_ALTER_SESSION Procedure Parameters
Parameter | Description |
---|---|
role_name |
The name of a valid role in the database. Required. |
session_parameter |
A parameter that can be set with a SQL |
The following call deletes a row in OLAP$ALTER_SESSION
that contains a value of OLAP_DBA
in the first column and QUERY_REWRITE_ENABLED=TRUE
in the second column.
EXECUTE olap_api_session_init.delete_alter_session('OLAP_DBA', 'SET QUERY_REWRITE_ENABLED=TRUE'); SELECT * FROM all_olap_alter_session WHERE role='OLAP_DBA'; no rows selected