| Login Problem with Database [message #352012] |
Sun, 05 October 2008 02:53  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
Hi,
I have installed oracle 9i on windows xp at home for test purpose. I have created a database using DBCA.
i found that the database accepts any login/password as sysdba apart from SYS/SYS or the password that i set during the database creation.
eg;
the database accepts asdf/asdf as sysdba and log in's...
but i set the sys/sandy as my log in id's to log in as sysdba.
Can anyone help me out. what could be the problem...
|
|
|
|
|
|
|
|
|
|
| Re: Login Problem with Database [message #352026 is a reply to message #352024] |
Sun, 05 October 2008 06:17  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
ya,, sure...
i did it... from administrative tools...
it worked for two database but for one of the database, i am still able to log in with any userid/password... i removed the privileges from ORA_DBA windows group as u said...
|
|
|
|
|
|
| Re: Login Problem with Database [message #352041 is a reply to message #352029] |
Sun, 05 October 2008 09:05 |
 |
Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
password file and its related parameter are only relevant for remote connection not local one.
You don't remove privileges from ORA_DBA, you have to remove users from ORA_DBA group.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
