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

From: "Ram Srinivasan" <srinivasanram2004@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 7 Aug 2007 17:48:40 -0400

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.

Follow-Ups:

Re: Can we revoke select priv from all_users tables??
From: Rumpi Gravenstein

RE: Can we revoke select priv from all_users tables??
From: Kirtikumar Deshpande

RE: Can we revoke select priv from all_users tables??
From: JOHNSTON, WAYNE

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

Other related posts: