Oracle DatabaseでDBMS_LOCK権限の割り当てと確認方法。
■DBMS_LOCK権限を付与する
※DBAで実施
GRANT EXECUTE ON SYS.DBMS_LOCK TO ユーザ名;
■オブジェクト権限を確認するSELECT文
SELECT * FROM dba_tab_privs;
SELECT * FROM dba_tab_privs where GRANTEE = '確認するユーザ' ;
■確認結果
SQL> SELECT * FROM dba_tab_privs where GRANTEE = 'OracleUSER' ;
GRANTEE OWNER
------------------------------ ------------------------------
TABLE_NAME GRANTOR
------------------------------ ------------------------------
PRIVILEGE GRA HIE
---------------------------------------- --- ---
OracleUSER SYS
DBMS_LOCK SYS
EXECUTE NO NO
SQL>