Monday, June 9, 2014

Oracle: Grant Select Privileges on tables to another user.

set feedback off
set trimspool on
set pagesize 10000
set linesize 1000
set heading off

spool doit.sql
select 'grant select on '||owner||'.'||table_name||' to articy;' from all_tables where owner = 'GOWEEKEND';
spool off

No comments:

Post a Comment