Access to Data Dictionary [message #51047] |
Mon, 22 April 2002 23:59 |
K. Prakash babu
Messages: 46 Registered: July 2001
|
Member |
|
|
hi
I am surprisingly able to access the data dictionary as a normal user. I didnt give any priviliges to this user except connect.
I can tell u in detail here...
I have a user with name SAMPLE_USER. I granted CONNECT,RESOURCE,DBA to SAMPLE_USER. Later i revoked RESOURCE & DBA from SAMPLE_USER. Now...If i say select * from v$parameter...I am able to veiw the list of parameters from v$parameter!!!!!
how is it possible??? Could anybody explain it..
Thanx in advance
|
|
|
Re: Access to Data Dictionary [message #51073 is a reply to message #51047] |
Tue, 23 April 2002 07:49 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
I did EXACTLY as you have mentioned and at the end, the user could not see any of the dictionary tables.
Did you grant any thing else ?
like 'select any table' to the user ?
You can also try and see. Repeat the same procedure as mentioned above.
|
|
|