http://www.dba.5341.com/
http://www.dba.5341.com/
I’ve run it to this before, so it’s
not that weird. But as far as I know the answer is NO. It’s called
PUBLIC for a reason. J
If there is a way to limit this access I’d
like to hear about it.
Tanks
Hotsos Enterprises
-----------------------
Hotsos Symposium March 4-8, 2007. Be
there.
From:
oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Verma, Amit
Sent: Thursday, June 01, 2006 5:14
PM
To: Oracle-L Freelists
Subject: PUBLIC grants
Is there a way to restrict a user from being able to access
tables on which privileges have been granted to public (like below)???
Grant select on <table_name> to public;
We have privs granted to public in our production system.
The requirement is to let couple of auditors view some (not all) data
temporarily using SQL*Plus.
I know it’s a weird question, but any help/suggestions
would be much appreciated.
-Amit.