spool /production/10_july_20_export_dump/grants_scripts/MUSAIB_permissions_10july2020.sql
set heading off
SET NEWPAGE NONE
SET FEEDBACK OFF
select 'grant ' || privilege || ' on ' || owner || '.' || table_name || ' to ' || grantee || ';'
from dba_tab_privs
where owner in ('MUSAIB')
order by owner, table_name, grantee;
select 'quit;' from dual;
select '/' from dual;
spool off;
quit;
/
set heading off
SET NEWPAGE NONE
SET FEEDBACK OFF
select 'grant ' || privilege || ' on ' || owner || '.' || table_name || ' to ' || grantee || ';'
from dba_tab_privs
where owner in ('MUSAIB')
order by owner, table_name, grantee;
select 'quit;' from dual;
select '/' from dual;
spool off;
quit;
/
No comments:
Post a Comment