PUBLIC grants

  • From: "Verma, Amit" <AVerma@xxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Jun 2006 16:14:11 -0500

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.

Other related posts: