Home » RDBMS Server » Server Administration » granting all system privileges (oracle 10g, windows)
granting all system privileges [message #434661] Thu, 10 December 2009 03:03 Go to next message
namb
Messages: 35
Registered: September 2009
Member
I want to create an exact copy of sys user with all the system privileges. how can i do that

thanks in advance
Re: granting all system privileges [message #434662 is a reply to message #434661] Thu, 10 December 2009 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It's simple: SYS has ALL privileges and roles.
But even if you grant all privileges you will not have sys privileges with your user.

Regards
Michel

[Updated on: Thu, 10 December 2009 03:09]

Report message to a moderator

Re: granting all system privileges [message #434666 is a reply to message #434662] Thu, 10 December 2009 03:18 Go to previous messageGo to next message
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
Michel Cadot
Messages: 64102
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

Previous Topic: Moving Indexes ... ???
Next Topic: to read the control.DBF
Goto Forum:
  


Current Time: Fri Dec 02 18:21:14 CST 2016

Total time taken to generate the page: 0.28629 seconds