Oracle DBA Scripts
Oracle Production support DBA Tips
Wednesday, January 13, 2010
Audit Table Permissions
select grantee from dba_tab_privs
where table_name='AUD$'
and grantee not in ('DELETE_CATALOG_ROLE')
and grantee not in
(select grantee from dba_role_privs where granted_role='DBA')
order by grantee;
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment