FreeLists / oracle-l / RE: PUBLIC grants

["Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>]

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.  :-)

 

If there is a way to limit this access I'd like to hear about it.

 

Tanks

 

Ric Van Dyke

Hotsos Enterprises

-----------------------

Hotsos Symposium March 4-8, 2007.  Be there.

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.