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.

Showing posts with label Prevent granting of privileges that have WITH GRANT option. Show all posts
Showing posts with label Prevent granting of privileges that have WITH GRANT option. Show all posts

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;