PASSWORDS

[andypara]

Where are the passwords kept? I need to find the password for a particular user. How can I do this? Is it a data dictionary table?

 

[Guest_imported]

Do you tzlk zbout the password of a schema (oracle users) ?

In this case, oracle scripts the password of those schemas, and you can see the scripts values in the view
dba_users

select username,password from dba_users;

 

[karluk]

Oracle won't let you query passwords. To do so would be an unbelievably serious security problem. Querying dba_users will only return an encrypted password, not the actual password.

If you can't remember your password, have someone with dba privileges log in and change your password.

alter user user_name identified by new_password;