| Oracle not asking for password [message #455932] |
Thu, 13 May 2010 11:00  |
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 #455983 is a reply to message #455932] |
Thu, 13 May 2010 22:59  |
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
