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

Archive for the ‘Password’ Category

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

Posted in Password | Leave a Comment »