The Fei's Tech Notes
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment