RE: Can we revoke select priv from all_users tables??

All:
  I am creating a user as:

create user test1 identified by fannymayofomaha default tablespace def001
temporary tablespace temp01;
  This user test1 has access to all the user_ tables and all_ tables. I believe that when a user is created he automatically receives the select priv to these all_ and user_ tables.

  Is there a way to REVOKE the select priv from the all_ tables for this user?

  Thanks for your input.

--

Sincerely
Ram Srinivasan
Charlottesville, VA.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 07 2007 - 16:48:40 CDT