SYS.DBMS_LOCK権限を割り当て

2018/8/31 Oracle

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>