Re: PUBLIC grants

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

--
http://www.freelists.org/webpage/oracle-l