Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.

Wednesday, January 13, 2010

Prevent granting of privileges that have WITH GRANT option

select grantee||': '||owner||'.'||table_name from dba_tab_privs
where grantable='YES'
and owner not in ('SYS','MDSYS','ORDPLUGINS',
'ORDSYS','SYSTEM','WMSYS','XDB','LBACSYS')
and grantee not in (select grantee from dba_role_privs where granted_role='DBA')
order by grantee;

No comments: