Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

DBA Connect as another user when the password is lost

Posted by Hendry chinnapparaj on May 17, 2010

select password from dba_users where username=’PA_AWR_USER’;

PASSWORD                     

——————————

577C8BBD5FDA53E8             

1 row selected.

alter user PA_AWR_USER identified by tiger;

User altered.

Connect pa_awr_user/tiger

alter user PA_AWR_USER identified by values ‘577C8BBD5FDA53E8’;

User altered.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: