SYS.OLAP_API_SESSION_INIT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

    SELECT USER#
      INTO user_num
      FROM SYS.USER$
     WHERE TYPE# = 0
       AND DEFROLE = 1
       AND NAME = roleName;

Line: 21

    SELECT COUNT(*)
      INTO num
      FROM SYS.OLAP$ALTER_SESSION
     WHERE ROLE# = roleNum
       AND TEXT = roleName;

Line: 41

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

Line: 42

        DBMS_OUTPUT.PUT_LINE('Row inserted');

Line: 60

  PROCEDURE delete_alter_session (roleName VARCHAR2, sqlStmt VARCHAR2) IS
    role_num INT;

Line: 68

      DELETE FROM SYS.OLAP$ALTER_SESSION
        WHERE ROLE# = role_num AND TEXT = alterStmt;

Line: 78

  END delete_alter_session;

Line: 82

    DELETE FROM olap$alter_session where role# NOT IN (
      SELECT user# FROM SYS.USER$ WHERE TYPE# = 0 AND DEFROLE = 1);