Home » RDBMS Server » Security » Regarding password file authentication
Regarding password file authentication [message #269556] Sun, 23 September 2007 06:26 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am working with 10g database .
I have set the remote_login_passwordfile parameter to exclusive


SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE

SQL> show parameter pass

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE




I tried connecting as sysdba and I was able to connect .

sqlplus '/as sysdba'

When i was trying to connect as sys with different random passwords specified i was able to connect too.

Though I didn't give sysdba permissions to other users they were also able to connect as sysdba .

Let me know what went wrong ?
Re: Regarding password file authentication [message #269557 is a reply to message #269556] Sun, 23 September 2007 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are in the OS dba group.
You can give what you want for username and password, Oracle does not care and connect you as sysdba.

Regards
Michel
Re: Regarding password file authentication [message #269616 is a reply to message #269556] Sun, 23 September 2007 21:27 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

OS Authentication has the priority over password file authentication.
Previous Topic: user unable to connect
Next Topic: Who created the database users
Goto Forum:
  


Current Time: Thu Nov 07 15:43:14 CST 2024