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 PUBLIC is granted with Object Permissions. Show all posts
Showing posts with label PUBLIC is granted with Object Permissions. Show all posts

Wednesday, January 13, 2010

PUBLIC is granted with Object Permissions

select owner||'.'||table_name||': '||privilege from dba_tab_privs
where grantee='PUBLIC'
and owner not in('SYS','CTXSYS','MDSYS','ODM','OLAPSYS','MTSSYS',
'ORDPLUGINS','ORDSYS','SYSTEM','WKSYS','WMSYS','XDB','LBACSYS',
'PERFSTAT','SYSMAN','DMSYS','EXFSYS');