SELECT 'GRANT 'PRIVILEGE' TO 'GRANTEE';' FROM DBA_SYS_PRIVS WHERE GRANTEE IN (); (for system privileges)
SELECT 'GRANT 'PRIVILEGE' TO 'GRANTEE';' FROM DBA_TAB_PRIVS WHERE GRANTEE IN (); (for object privileges)
SELECT 'GRANT 'GRANTED_ROLE' TO 'GRANTEE ';' FROM DBA_ROLE_PRIVS WHERE GRANTEE IN ();
No comments:
Post a Comment