Search This Blog

Wednesday, December 21, 2011

get grant script

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