9i password file error
I am trying to know new features of 9i and one strange thing I have noticed is that I can get in as sys with any password as sysdba ,which tells me password file is not being checked for sys logins.
I tried to recreate the password file but still the same.
you need not have to type any password when u login as a user belonging to DBA group.
$ connect ' / as sysdba'
sql>connect sys as sysdba
It wont prompt u for any password
That is some external role called OSDBA doing this trick.
Click Here to Expand Forum to Full Width