This content has been marked as final. Show 2 replies
schema level privileges is not possible in oracle..............
but you can make a script to grant privilege at object level
SQL> set head off
SQL> select 'grant select on '||OWNER||'.'||TABLE_NAME||' to JOHN;' as grant_select FROM dba_tables WHERE owner='SCOTT';
grant select on SCOTT.DEPT to JOHN;
grant select on SCOTT.EMP to JOHN;
grant select on SCOTT.SALGRADE to JOHN;
grant select on SCOTT.BONUS to JOHN;
you can replace select on with insert on or update on or with delete on respectively
I already know what you are suggesting, but thanks for looking into my post.