Home » RDBMS Server » Security » Sys password change
Sys password change [message #213730] Fri, 12 January 2007 01:26 Go to next message
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.
Re: Sys password change [message #213745 is a reply to message #213730] Fri, 12 January 2007 03:02 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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
Re: Sys password change [message #213824 is a reply to message #213745] Fri, 12 January 2007 07:55 Go to previous messageGo to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

Yes I am able to connect with any password, i want to change it. how is it possible?
Re: Sys password change [message #213838 is a reply to message #213824] Fri, 12 January 2007 08:36 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Set the following in the sqlnet.ora file:

SQLNET.AUTHENTICATION_SERVICES=NONE
Re: Sys password change [message #213840 is a reply to message #213838] Fri, 12 January 2007 08:39 Go to previous messageGo to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

Thank you,
Its working.

Regards
Amit Nanote
Re: Sys password change [message #213844 is a reply to message #213840] Fri, 12 January 2007 08:44 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Glad it helped.

Be careful to lock the privileges down on the file, otherwise users in the appropriate group could just change the file itself.
Previous Topic: OS Authentication
Next Topic: user creation
Goto Forum:
  


Current Time: Thu Dec 08 18:46:10 CST 2016

Total time taken to generate the page: 0.14257 seconds