OraFAQ Forum: Server Administration » Password For SYS User

Home » RDBMS Server » Server Administration » Password For SYS User

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

Password For SYS User [message #172275]

Mon, 15 May 2006 15:16

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

Hi,

I have a database 9.2.0.3 and i have changed the SYS user password using Alter User command,once i changed the SYS password....Still i can log on to the Database with Old Password.......i.e even i can log on to the database using SYS default Password.

Did anybody encountered this issue.....

Regards

Report message to a moderator

Re: Password For SYS User [message #172276 is a reply to message #172275]

Mon, 15 May 2006 15:19

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

At the prompt:
>sqlplus
username: sys / as sysdba
password: <anything>

now do a alter user sys identifed by <a well formed password>;

This *should* work on your version.
Neil.

[Updated on: Mon, 15 May 2006 15:19]

Report message to a moderator

Re: Password For SYS User [message #172359 is a reply to message #172275]

Tue, 16 May 2006 03:23

kmsalih
Messages: 197
Registered: March 2006

Senior Member

You are able to logon using "/as sysdba" b'coz the OS user is a member of ORA_DBA Group.

If you are not the member you can't logon usin "/as sysdba"

Try it.

Regards
Salih KM

Report message to a moderator

Previous Topic:	create directory problem
Next Topic:	To get all the views pointing to a particular table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:28:06 CDT 2024