OraFAQ Forum: Security » forget my sys password

Home » RDBMS Server » Security » forget my sys password

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

forget my sys password [message #165561]

Thu, 30 March 2006 23:02

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

Hi master
Sorry for disturb you
I forget my sys password and I want create new user with dba how I create new user with dba roles or how I get my sys password

Thanking you

Aamir

Report message to a moderator

Re: forget my sys password [message #165573 is a reply to message #165561]

Thu, 30 March 2006 23:40

kmsalih
Messages: 197
Registered: March 2006

Senior Member

hi,

Try this

Go to Server
$ sqlplus "/as sysdba"

Regards
SALIH KM Cool

Report message to a moderator

Re: forget my sys password [message #165886 is a reply to message #165561]

Mon, 03 April 2006 03:38

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

Senior Member

Yes,
I have had good luck using kmsalih's method.
or
>sqlplus
>username: sys / as sysdba
>password: <enter anything> - I think it is os authcated?

Now change sys's password to something you know:
sql>alter user sys identified by <a good password>;

You can also:
create user <some username, like oradba> identified by <a good password>

assign oradba a profile and grant connect and dba roles to him.

Then log in as oradba and issue the sql statement:
alter user sys identified by <a different good password>;

Report message to a moderator

Re: forget my sys password [message #165909 is a reply to message #165886]

Mon, 03 April 2006 04:52

madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india

Member

to proceed with the above method , OS user should be in dba or (what ever group authorized )

Thanks & Regards
Madhu

Report message to a moderator

Previous Topic:	Using sticky bit on Oracle directory & umask
Next Topic:	logon trigger cannot prevent DBA account from logging in database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 15:07:18 CDT 2025