[Tibero] User Privileges, Role 조회 (2)

객체에 대한 다른 User들의 Privileges Script와 User가 가진 다른 User들의 객체 Privileges Script를 생성할 수 있습니다.

 

Note! Tibero 및 Oracle 환경 내에서 생성 가능합니다.

 

 

User의 객체에 대한 다른 User들의 Privileges Script 생성

SQL> SELECT 'GRANT '||PRIVILEGE||' ON '||OWNER||'.'||TABLE_NAME||' TO '||GRANTEE||';'            FROM DBA_TAB_PRIVS            WHERE OWNER IN ('SCOTT')            ORDER BY OWNER, TABLE_NAME, GRANTEE, PRIVILEGE; 'GRANT'||PRIVILEGE||'ON'||OWNER||'.'||TABLE_NAME||'TO'||GRANTEE||';' ----------------------------------------------------------------------------------------------------------------------------------- GRANT ALTER ON SCOTT.BONUS TO HR; GRANT ALTER ON SCOTT.BONUS TO PROD; GRANT DELETE ON SCOTT.DEPT TO HR; GRANT SELECT ON SCOTT.SALGRADE TO HR; GRANT SELECT ON SCOTT.SALGRADE TO PROD;

 

 

User가 가진 다른 User들의 객체 Privileges Script 생성

SQL> SELECT 'GRANT '||PRIVILEGE||' ON '||OWNER||'.'||TABLE_NAME||' TO '||GRANTEE||';'            FROM DBA_TAB_PRIVS            WHERE GRANTEE IN ('HR')            ORDER BY GRANTEE,OWNER,TABLE_NAME,PRIVILEGE; 'GRANT'||PRIVILEGE||'ON'||OWNER||'.'||TABLE_NAME||'TO'||GRANTEE||';' ---------------------------------------------------------------------------------------------------------------------------------- GRANT SELECT ON ORDDATA.ORDDCM_ANON_ATTRS TO HR; GRANT ALTER ON SCOTT.BONUS TO HR; GRANT DELETE ON SCOTT.DEPT TO HR; GRANT SELECT ON SCOTT.SALGRADE TO HR; GRANT INSERT ON SYSMAN.MGMT_COLLECTION_TEMPLATE_CREDS TO HR; GRANT DELETE ON SYSMAN.MGMT_HOST_CREDENTIALS TO HR; GRANT SELECT ON SYSMAN.MGMT_USER_CAS TO HR;