OraFAQ Forum: Security » Sys password change

Home » RDBMS Server » Security » Sys password change

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sys password change [message #213730]

Fri, 12 January 2007 01:26

amit_nanote
Messages: 56
Registered: July 2005
Location: Indore

Member

HI ,
I am trying to change the password of the sys user from sys to syssys. After executing scucessful alter user command I log off from oracle and try to connect using Sys user with sys password as sysdba. It logs into the user, Why it is so?
Even it accepts any letter to login to the account.
What change Do I make to keep the changes and implement the password access?

Thank you.

Report message to a moderator

Re: Sys password change [message #213745 is a reply to message #213730]

Fri, 12 January 2007 03:02

Frank Naude
Messages: 4595
Registered: April 1998

Senior Member

If your OS user belongs to the "dba" group on Unix, or the "ORA_DBA" (ORA_sid_DBA) group on Windows, you can connect with any password. To confirm try this:

Quote:

CONNECT SYS/CRAP AS SYSDBA

Report message to a moderator