Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to know the user password?
violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
>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 :)
Assuming you have the correct grants/permissions for your login then 'Alter user <username> identified by <newpassword>' will change <username>'s password to <newpassword> -
To reply please remove the 'nospam' part of the address Received on Tue Sep 29 1998 - 11:13:40 CDT