Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges
ORA-01031: insufficient privileges [message #358104] Sat, 08 November 2008 10:22 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Hi all,

I have an oracle 10.2.0.2 stand-alone database installed on a SuSE SLES10.1 machine. I would like the root user to have sysdba privilege. The user 'root' is a member of the "dba" group. However, when I try to connect to the database from the user 'root', it throws an error:
sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Nov 8 19:10:55 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

Other OS users part of the "dba" group have no problem connecting as sysdba. I dont understand why its only a problem with the user root.

Thanks.
Re: ORA-01031: insufficient privileges [message #358107 is a reply to message #358104] Sat, 08 November 2008 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Whatever you would like NEVER uses root for sysdba.

Regards
Michel
Re: ORA-01031: insufficient privileges [message #358110 is a reply to message #358104] Sat, 08 November 2008 10:53 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
It is the application requirement for user root to be part of the dba group
Re: ORA-01031: insufficient privileges [message #358115 is a reply to message #358110] Sat, 08 November 2008 11:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, put it but don't use it.

Regards
Michel
Re: ORA-01031: insufficient privileges [message #358116 is a reply to message #358115] Sat, 08 November 2008 11:47 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
But I dont understand why I get the error 'ORA-01031: insufficient privileges' from the user root
Re: ORA-01031: insufficient privileges [message #358119 is a reply to message #358116] Sat, 08 November 2008 12:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 18089.1

Regards
Michel
Re: ORA-01031: insufficient privileges [message #358136 is a reply to message #358119] Sun, 09 November 2008 00:40 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
The note also says to change the primary group of root to dba if it needs sysdba privileges:
[Edit MC: Metalink note content removed]

But I dont know the implications of making the primary group of user root as "dba"

[Updated on: Sun, 09 November 2008 00:53] by Moderator

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358137 is a reply to message #358136] Sun, 09 November 2008 00:54 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is one of the reasons why I said "don't do it".
I don't see any reason to use root for something it is not made for.
root manages the OS, to manage applications/software there must be other accounts.

Regards
Michel

[Updated on: Sun, 09 November 2008 00:55]

Report message to a moderator

Previous Topic: query about system global area
Next Topic: Archive log transfer...
Goto Forum:
  


Current Time: Tue Dec 06 00:11:45 CST 2016

Total time taken to generate the page: 0.06704 seconds