Title: RE: DBA_USERS view
-Original Message-
From: Stefan Jahnke [mailto:[EMAIL PROTECTED]]
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
You can use it to swap out a user's password for diagnostics. An example is
listed in the Oracle DBA Handbook. Basically you can create a temp table to
store the value:
CREATE TABLE TEMP_USER AS SELECT USERNAME, PASSWORD FROM DBA_USERS WHERE
USERNAME = 'XYZ';
Then alter the user for
Hi,
You can try http://www.uaex.edu/srea/
This is a script for you to login as other user without using their
password, basically that script change the whatever user password to
something else and start login with that new password and change it back
when you done what ever you do.
User can