Our Remote DBA Clients

Oracle Tips by Burleson

Chapter 4 General Oracle Security

creates numerous permutations for the grants to be given, and is a management nightmare.

The following script shows whether you have any granted privileges with the grant option.

select
   owner,
   table_name,
   grantor,
   privilege
from
   dba_tab_privs
SEE CODE DEPOT FOR FULL SCRIPT
and
   owner not in ('SYS','SYSTEM')
/

If there are any such privileges, immediately revoke them and re-grant them without the grant option. The following script shows privileges where the original owner did not grant the privileges.

select
   owner,
   table_name,
   grantor,
   privilege
from
   dba_tab_privs
SEE CODE DEPOT FOR FULL SCRIPT
and

The above text is an excerpt from:

Oracle Privacy Security Auditing

The Final Word on Oracle Security

This is the only authoritative book on Oracle Security, Oracle Privacy, and Oracle Auditing written by two of the world’s leading Oracle Security experts.

This indispensable book is only $39.95 and has an immediate download of working security scripts:

http://rampant-books.com/book_2003_2_audit.htm