| problem with password mgmt for oracle 9i [message #60988] |
Thu, 18 March 2004 01:41  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
hi
i am having one problem with my database server
my environment is windows 2000 adv.erver and oracle 9i(9.0) version
my database is working but when i have created password file to connect as DBA'S it has created.
but when i am logging to database as SYS/password as sysdba
i am able to login with any password or even with any string which typing at sqlplus prompt can anyone of u tell how to connect to database only with a password which i have given in password file waiting for early response
advance thanks.
dilip
|
|
|
|
| Re: problem with password mgmt for oracle 9i [message #60992 is a reply to message #60988] |
Thu, 18 March 2004 03:40  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
This is normal behaviour. If you belong to the ORA_DBA group on Windows (or DBA on UNIX), you don't need a password to connect to a SYSDBA account. In fact, you don't even need to specify a valid username.
Examples:
SQL> connect SYS/crap AS SYSDBA
Connected.
SQL> connect SYS/invalid AS SYSDBA
Connected.
SQL> connect NOBODY/NOPASSWORD AS SYSDBA
Connected.
SQL> show user
USER is "SYS"
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
