November 08, 2012

GRANT READ WRITE ON SCHEMA OBJECTS

select 'grant read,write on '||owner||'.'||object_name||' to '||'YOURREADWRITE_USER'||';' from all_objects where owner='&YOUROBJECT_OWNER';

1 comment: