Script
Dear Colleague,
Some Should help me edit my script
I want to revoke privileges (DELETE,INSERT and UPDATE) from group of non system users on my oracle 9i Database. I only want to give select privilege to all non-system users.
revoke delete on table_name
in (
select table_name
from dba_tab_privs
where grantee in
(select username
from dba_users
where username not in (select distinct(owner) from dba_objects)))
Some Should help me edit my script
I want to revoke privileges (DELETE,INSERT and UPDATE) from group of non system users on my oracle 9i Database. I only want to give select privilege to all non-system users.
revoke delete on table_name
in (
select table_name
from dba_tab_privs
where grantee in
(select username
from dba_users
where username not in (select distinct(owner) from dba_objects)))
0