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

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Tue, 7 Aug 2007 19:40:55 -0700 (PDT)
Message-ID: <555801.37080.qm@web51812.mail.re2.yahoo.com>

Hi Ram,

 What are you trying to achieve?  

 Yes, you are correct. All users have access to user_% views to see things from their own schema, and all users can use all_% views to see things that they are *allowed* to see - by default and by granted privileges.  

 By default access to all_% views is granted to PUBLIC. You will have to revoke the privilege from PUBLIC and selectively grant it to all the rest of the users/roles etc. If are just playing with grants and privileges, you can experiment with such things in your sandbox/playpen database. I am not suggesting that you do this in a production environment.

 You can find more information about user privileges and access control in the Oracle Concepts, and Administration Guides.

 Regards,

• Kirti
  • Ram Srinivasan <srinivasanram2004_at_gmail.com> wrote:

> 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.
>

---

Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 07 2007 - 21:40:55 CDT