Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: PUBLIC grants

Dennis Williams

2006-06-01

Replies:

Amit,
 
Oh, just what is it you DON'T want the auditors to see???? Usually auditing operates on the principle that nothing is hidden from the auditors. I was just reading about the auditors that audit the CIA.
Are these tables where it is technically possible to revoke PUBLIC?
Okay, you could:
   1. Create a new role.
   2. Grant the tables in question to that role.
   3. Grant that role to everybody except the auditors.
   4. Revoke PUBLIC from those tables.
 
Dennis Williams

 
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.