Home » SQL & PL/SQL » SQL & PL/SQL » Insufficiant privilages
Insufficiant privilages [message #234183] Mon, 30 April 2007 05:41 Go to next message
geoissac
Messages: 1
Registered: April 2007
Junior Member
Hi

I am logging in as DBA and when i am tryin to do a instance shutdown
it shows insufficiant privliages.

kindly help

Regards

george
Re: Insufficiant privilages [message #234186 is a reply to message #234183] Mon, 30 April 2007 05:45 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

I suggest you read this
Re: Insufficiant privilages [message #234282 is a reply to message #234183] Mon, 30 April 2007 13:18 Go to previous messageGo to next message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
DBA doesn't have the ability to shutdown the database. Only sysdba or sysoper does. They are two privileges that must be asked for at the time of login. See the following link


http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12015.htm
Re: Insufficiant privilages [message #234357 is a reply to message #234282] Tue, 01 May 2007 02:22 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
...and this is the moment where everybody should be happy that the database doesn't allow just anyone to shut it down. Very Happy

MHE
Previous Topic: problem while sending mail thru oracle --
Next Topic: default(max) size of NUMBER datatype in oracle-10g
Goto Forum:
  


Current Time: Sun Dec 04 12:42:32 CST 2016

Total time taken to generate the page: 0.09110 seconds