OraFAQ Forum: Security » ORA-01031: insufficient privileges

Home » RDBMS Server » Security » ORA-01031: insufficient privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges [message #260960]

Tue, 21 August 2007 06:32

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

i issue the command like

C:\>sqlplus "/ as sysdba" on window environment

but give the error like

ERROR:
ORA-01031: insufficient privileges

how can resolve error

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #260966 is a reply to message #260960]

Tue, 21 August 2007 06:45

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

how can resolve error

Just searching.
This error is made and posted almost once per week.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #260967 is a reply to message #260960]

Tue, 21 August 2007 06:47

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

The user by which you are invoking sqlplus commnad that user must be a member of OSDBA group.

In unix make the user of group dba and in windows ORA_DBA.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #261024 is a reply to message #260967]

Tue, 21 August 2007 09:37

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

In addition to ARJU

change sqlnet.ora file "sqlnet.authentication_services=NTS"

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #261121 is a reply to message #260960]

Tue, 21 August 2007 22:04

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I want to say one thing, May be I am wrong.

The parameter sqlnet.authentication_services enables just no or one or more authentication services.(NONE,'...',ALL).

sqlnet.authentication_services=NTS

1.This setting has no impact if you are in server machine.Only if you are the user of OSDBA group you can connect by / as sysdba

2. Above settings has no impact if the server and client machine are both run on linux.

3. That settings will have only impact if the client machine is WINDOWS NT Native ( that is Windows XP,2003).

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #261175 is a reply to message #261121]

Wed, 22 August 2007 01:49

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

1.This setting has no impact if you are in server machine.Only if you are the user of OSDBA group you can connect by / as sysdba

These 2 points are in conflict.
This has impact if you are on server and want to connect with /.
This has no impact if you are not on server or don't want to connect with /.

Quote:

2. Above settings has no impact if the server and client machine are both run on linux

The NTS setting is specific to Windows (as its name says).
If you put this in linux you will no more be able to connect as /.

Quote:

3. That settings will have only impact if the client machine is WINDOWS NT Native

It is important on server side.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #261190 is a reply to message #260960]

Wed, 22 August 2007 02:11

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Thank You Michel for clarifying it. I should write it after testing.

Report message to a moderator

Previous Topic:	Find IP Addresses
Next Topic:	Prevent DBA to change password of owner of encrypted data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 03:18:01 CST 2025