|
|
Re: granting all system privileges [message #434666 is a reply to message #434662] |
Thu, 10 December 2009 03:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
namb
Messages: 35 Registered: September 2009
|
Member |
|
|
When i am connecting any normal users as sysdba i can have access to whole Database architecture is there any way to restrict that
for eg if i have a user atten and i do
connect atten as sysdba
password: i just enter the normal password for atten
it still allows access as sysdba is there any way to restrict that
|
|
|
Re: granting all system privileges [message #434671 is a reply to message #434666] |
Thu, 10 December 2009 03:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
When you are connected as sysdba you are no more connect as normal user but as SYS. Just execute "show user" and you will see it.
Quote:it still allows access as sysdba is there any way to restrict that
Yes, don't put the user in OS dba group and/or revoke SYSDBA privilege from it.
But what is the relation with this point and the original question?
Regards
Michel
[Updated on: Thu, 10 December 2009 03:38] Report message to a moderator
|
|
|