Home » RDBMS Server » Security » Oracle not asking for password (10g,Hp unix)
Oracle not asking for password [message #455932] Thu, 13 May 2010 11:00 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
When I login into Oracle using / with sysdba privilage it is not asking for password.Where to set this and what is the meaning of /.


What is the diffrence between sysdba and sysoper.And what are the default user created when we instal oracle in a system with what privilage.

Questions may be amateur but pls answer..
Re: Oracle not asking for password [message #455934 is a reply to message #455932] Thu, 13 May 2010 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66774
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not asking for password because you are in the OS "dba" group.

The difference between the OS roles are clearly described in the documentation.
Database Administrator's Guide
Chapter 1 Overview of Administering an Oracle Database
Section Database Administrator Authentication
Subsection Administrative Privileges
Paragraph SYSDBA and SYSOPER

Regards
Michel
Re: Oracle not asking for password [message #455983 is a reply to message #455932] Thu, 13 May 2010 22:59 Go to previous messageGo to next message
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
Member
Hi,
You can set parameter to NONE instead of NTS in sqlnet.ora file to disable this.
SQLNET.AUTHENTICATION_SERVICES= (NONE)

C:\Documents and Settings\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 14 09:25:25 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


After resetting to NTS:
C:\Documents and Settings\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 14 09:25:48 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
sys@LM>


Regards
Lalit

[Updated on: Thu, 13 May 2010 23:00]

Report message to a moderator

Re: Oracle not asking for password [message #455985 is a reply to message #455983] Thu, 13 May 2010 23:15 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
>After resetting to NTS:
NTS does not work well on *NIX which OP has.
Re: Oracle not asking for password [message #456468 is a reply to message #455932] Tue, 18 May 2010 02:10 Go to previous messageGo to next message
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
Member
Ohh,
Thanks for pointing that.
I didn't noticed that OP is on *NIX platform.
My bad. Sad
Re: Oracle not asking for password [message #457458 is a reply to message #456468] Mon, 24 May 2010 10:32 Go to previous message
sosplc
Messages: 1
Registered: May 2010
Location: London
Junior Member
The same with me I didn't notice it neither... thanks
Previous Topic: cannot startup the DB because Audit file directory not exist
Next Topic: Security policies for products
Goto Forum:
  


Current Time: Sat Jan 18 02:58:40 CST 2020