Home » Other » Training & Certification » how to allow full access/control to a Oracle user?
how to allow full access/control to a Oracle user? [message #266002] Sat, 08 September 2007 18:01 Go to next message
sam_achilles
Messages: 4
Registered: January 2007
Location: IL
Junior Member

Hello everyone,

Please can anyone answer to my question.

Q) how to allow full access/control to a Oracle user?

Thanks in advance.
Re: how to allow full access/control to a Oracle user? [message #266003 is a reply to message #266002] Sat, 08 September 2007 19:19 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
sam_achilles wrote on Sat, 08 September 2007 19:01

Q) how to allow full access/control to a Oracle user?

Not sure what you mean by this? If your intention is to give TOTAL control to a user you could grant SYSDBA to the user.
Re: how to allow full access/control to a Oracle user? [message #266020 is a reply to message #266002] Sun, 09 September 2007 00:30 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to be more precise in your question.
As Brian said you can grant SYSDBA but in this case you are no more this user but acts as SYS.

But maybe is this just one more stupid interview question.

Regards
Michel
Previous Topic: sql /pl sql practice
Next Topic: decode problem
Goto Forum:
  


Current Time: Fri Dec 09 11:55:15 CST 2016

Total time taken to generate the page: 0.05331 seconds