Re: PUBLIC grants

Amit,

Can you not create a view of the data you want to allow to the auditors? Then grant select on the newly created view to whomsoever you want to keep in the dark.

r,

Gus

Verma, Amit wrote:

> 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