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.

Report message to a moderator

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.

Report message to a moderator

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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 23 06:36:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.