Friday, 23 September 2011

grant select on all objects in a schema to another user

Spool priv.sql
select 'grant select on &&USER'||'.'||object_name|| ' to &ROLE;' from dba_objects where owner='&&USER';
@priv.sql

No comments:

Post a Comment