DBA Data[Home] [Help]

SYS.OLAP_API_SESSION_INIT dependencies on USER$

Line 8: FROM SYS.USER$

4: user_num INT;
5: BEGIN
6: SELECT USER#
7: INTO user_num
8: FROM SYS.USER$
9: WHERE TYPE# = 0
10: AND DEFROLE = 1
11: AND NAME = roleName;
12: RETURN user_num;

Line 83: SELECT user# FROM SYS.USER$ WHERE TYPE# = 0 AND DEFROLE = 1);

79:
80: PROCEDURE clean_alter_session IS
81: BEGIN
82: DELETE FROM olap$alter_session where role# NOT IN (
83: SELECT user# FROM SYS.USER$ WHERE TYPE# = 0 AND DEFROLE = 1);
84: END clean_alter_session;
85:
86: -- BEGIN -- initialization part starts here
87: END OLAP_API_SESSION_INIT;