Re: How to know the user password?

You cannot get to the actual password for a user. You can change it to something temporary and change it back to what it was originally.

If this is what you are looking at doing,

select password from dba_users;

The password will be encrypted. Take note of this.

alter user xxx identified by xxx;

Change it back using alter user xxx identified by values 'the value returned by the query on dba_users';

Obviously you need to be either a DBA or granted with the alter user sys priv.

Sridhar Subramaniam
Violin wrote in message <3615301f.3784813_at_news.twsc.pouchen.com.tw>...
>Hello,
>I have a question,maybe you can help me!
>I have several users on my database(7.3)
>Of course each user with their own password.
>But how to know every user's password?
>
>'Cause not all the users are created by me,
>I don't know some users' pwd.
>'Cause I can't change the original pwd,
>the command is not proper for me:
>ALTER USER user IDENTIFIED password.
>
>So,how to know the user's password?
>PLEASE give me some tips,I'll appreciate for your help!
>And please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
Received on Tue Sep 29 1998 - 10:17:27 CDT