Home » RDBMS Server » Security » Login Problem with Database (Oracle 9i, Windows)
Login Problem with Database [message #352012] Sun, 05 October 2008 02:53 Go to next message
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 #352018 is a reply to message #352012] Sun, 05 October 2008 04:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When your OS user is in ORA_DBA Windows group, Oracle does not care of the login/password you give to connect as sysdba and directly connects you.

Regards
Michel
Re: Login Problem with Database [message #352023 is a reply to message #352018] Sun, 05 October 2008 06:03 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
can i know what can i do further on this...
Re: Login Problem with Database [message #352024 is a reply to message #352023] Sun, 05 October 2008 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/348951/102589/?#msg_348951

Please search a little bit before posting, this is a FAQ.

Regards
Michel
Re: Login Problem with Database [message #352026 is a reply to message #352024] Sun, 05 October 2008 06:17 Go to previous messageGo to next message
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 #352029 is a reply to message #352026] Sun, 05 October 2008 06:29 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
hey,..
i did shutdown and started the database after changing the REMOTE_LOGIN_PASSWORD initialization file from EXCLUSIVE to SHARED and it worked...

Thanks .....
Re: Login Problem with Database [message #352041 is a reply to message #352029] Sun, 05 October 2008 09:05 Go to previous message
Michel Cadot
Messages: 68624
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
Previous Topic: DENY over other rights
Next Topic: HOW TO RESTRICT THE USER FROM DISABLING TRIGEER STATUS
Goto Forum:
  


Current Time: Thu Mar 28 10:24:05 CDT 2024