| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA_USERS view
> -----Original Message-----
> From: Stefan Jahnke [mailto:stefan.jahnke_at_d2vodafone.de]
>
> what information does the PASSWORD column in the DBA_USERS
> view provide.
> I know that it's the encrypted user password, but how can I
> actually use
> it ?
> For example: Can I reassign a password to a user via his encrypted
> password ?
> or: Can I test a logon with another user's encrpyted user password to
> test the logon ?
> I tried stuff like connect myuser/0CE92663BBC6FC34_at_MYDB, but that
> doesn't seem to work.
I forget, did anyone answer this question? You can use it with the (undocumented as far as I know) 'identified by values' option of the alter user statement. This can be handy if you want to sign on as user X without changing their password. Make their password something you know, login with that password, then change their password back to the old password. Example:
SQL> create user x identified by old_password ;
User created.
SQL> grant create session to x ;
Grant succeeded.
SQL> select password from dba_users where username = 'X' ;
PASSWORD
SQL> connect x/old_password
Connected.
SQL> alter user x identified by new_password ;
User altered.
SQL> connect x/new_password
Connected.
SQL> alter user x identified by values 'D64698D364A3B171' ;
User altered.
SQL> connect x/old_password
Connected.
SQL>
>
> TIA ...
>
> --
> Regards,
> Stefan Jahnke
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stefan Jahnke
> INET: stefan.jahnke_at_d2vodafone.de
 |
 |