SYS.OLAP_API_SESSION_INIT dependencies on OLAP$ALTER_SESSION

Line 23: FROM SYS.OLAP$ALTER_SESSION

19: num INT;
20: BEGIN
21: SELECT COUNT(*)
22: INTO num
23: FROM SYS.OLAP$ALTER_SESSION
24: WHERE ROLE# = roleNum
25: AND TEXT = roleName;
26: RETURN num;
27: END newRole;

Line 41: INSERT INTO SYS.OLAP$ALTER_SESSION (ROLE#, TEXT) VALUES (role_num, alterStmt);

37: role_num := getRoleID(roleName);
38: alterStmt := 'ALTER SESSION ' || UPPER(sqlStmt);
39: isNewRole := newRole(role_num, alterStmt);
40: IF isNewRole = 0 THEN
41: INSERT INTO SYS.OLAP$ALTER_SESSION (ROLE#, TEXT) VALUES (role_num, alterStmt);
42: DBMS_OUTPUT.PUT_LINE('Row inserted');
43: COMMIT;
44: ELSE
45: RAISE duplicate_role;

Line 68: DELETE FROM SYS.OLAP$ALTER_SESSION

64: DECLARE
65: BEGIN
66: role_num := getRoleID(roleName);
67: alterStmt := 'ALTER SESSION ' || UPPER(sqlStmt);
68: DELETE FROM SYS.OLAP$ALTER_SESSION
69: WHERE ROLE# = role_num AND TEXT = alterStmt;
70: COMMIT;
71: END;
72: EXCEPTION

Line 82: DELETE FROM olap$alter_session where role# NOT IN (

78: END delete_alter_session;
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