| Privileges [message #62944] |
Wed, 25 August 2004 21:48  |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi,
I've a user called KANAK in Oracle... He can access all Data Dictionary... How can I revoke all Data Dictionary Right from him??... I've administration access.....
Thanks
|
|
|
|
| Re: Privileges [message #62945 is a reply to message #62944] |
Thu, 26 August 2004 00:18  |
Vaag
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
revoke select any dictionary from kanak ;
would restrict his access to dictionary
hope it helps
|
|
|
|
| Re: Privileges [message #62949 is a reply to message #62945] |
Thu, 26 August 2004 07:24 |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
Even if that doesnt work try this
revoke select any table from KNANAK;
set this init.ora parameter & start the database
o7_dictionary_accesibility=false
hope this helps
satish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
