| Regarding password file authentication [message #269556] |
Sun, 23 September 2007 06:26  |
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 ?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
