|
|
|
|
| Re: granting all system privileges [message #434666 is a reply to message #434662] |
Thu, 10 December 2009 03:18   |
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 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
