Monday, November 17, 2008

Reverse SQL of grant role

select 'grant ' privilege ' on ' table_name ' to ' grantee ';' from dba_tab_privs where grantor='Jeff';

No comments: