Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> PUBLIC grants

PUBLIC grants

From: Verma, Amit <AVerma_at_chx.com>
Date: Thu, 1 Jun 2006 16:14:11 -0500
Message-ID: <51338F3CEE91164C89AFCC010FEC7F6F0477A60C@MX3.chx.com>


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.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 01 2006 - 16:14:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US