Home » RDBMS Server » Security » sys dba authentication (oracle 9.2.0.4 on Win 2K)
sys dba authentication [message #294605] Fri, 18 January 2008 03:06 Go to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
I created a new service using ORADIM named "test1". Created a initTest1.ora file containing parameter remote_login_passwordfile=Exclusive. Both the init and password files are at default location. Even I have created password file, when I write sqlplus / as sysdba it connect and shows "connected to an idle instance" just like in case of OS authentication. After startup when I see "show parameter remote_login_passwordfile" it shows Exclusive. Then how it is using OS authentication?
Re: sys dba authentication [message #294607 is a reply to message #294605] Fri, 18 January 2008 03:10 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
when I write sqlplus / as sysdba it connect and shows "connected to an idle instance" just like in case of OS authentication

Because you are local and in ORA_DBA OS group.
OS authentication is done BEFORE password file is checked.

Regards
Michel
Previous Topic: how to identifies list of roles
Next Topic: How to enable auditing for a patricular table in oracle 9i
Goto Forum:
  


Current Time: Thu Mar 28 08:01:45 CDT 2024