Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can we revoke select priv from all_users tables??
I recently received a copy of a 'best practices' document that says that users should not have access to any 'all_' views. Its a really stupid idea, I suspect that whoever put it in the document thinks that all actually looks at all, as opposed to just what the user has access to.-- http://www.freelists.org/webpage/oracle-l Received on Wed Aug 08 2007 - 11:39:28 CDT
On 8/8/07, JOHNSTON, WAYNE <wjohnsto@fccj.edu> wrote:Ram,
It may be just my nature, but I have to ask why you want to do this? Is there some audit requirement that a user not query all_tables to see the tables he has been granted access to?
Wayne Johnston
Adabas Database Administrator
Oracle Database Administrator
FCCJ: 904-997-2907
CELL: 904-607-1889
No one shall be subjected to arbitrary arrest, detention or exile.
Article 9. United Nations Universal Declaration of Human Rights, December 10, 1948
From: oracle-l-bounce@freelists.org [mailto: oracle-l-bounce@freelists.org] On Behalf Of Ram Srinivasan
Sent: Tuesday, August 07, 2007 5:49 PM
To: oracle-l@freelists.org
Subject: 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.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'