Here is a script I use all the time to run jobs for other users. It saves the current
password, sets the password to temp, connects to user, and sets it back to original
setting. Now you are logged in as the new user but their password was only changed
for less than a second. The script also
this is documented in Kevin Loney's 7.3 edition of the DBA Handbook
(look for become_another_user.sql)
--- [EMAIL PROTECTED] wrote:
> Hi all,
>
> I've got a little question, which i can't find simply on metalink.
> I've got one user with a not know password and i want to temporary
> change
> it
@civ.utwente.To: Multiple recipients of list ORACLE-L
nl <[EMAIL PROTECTED]>
Sent by: rootcc:
It's just
ALTER USER username IDENTIFIED BY VALUES 'hex-key-whatever';
Substituting the username and password value from dba_users as appropriate.
There are scripts that save it in a file with the commands to switch it back,
but it's easy enough to do manually.
Simon Anderson
> Hi all,
>
>
//www.inplan.de
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 24. Oktober 2001 16:10
An: Multiple recipients of list ORACLE-L
Betreff: Help with passwords
Hi all,
I've got a little question, which i can't find simply on metal
save the key
then to set it back
alter user idenfified by values 'HEX KEY HERE';
joe
>>> [EMAIL PROTECTED] 10/24/01 10:10AM
>>>Hi all,I've got a little question, which i can't find
simply on metalink.I've got one user with a not know password and i want to
temporary changeit;s password.
Hi all,
I've got a little question, which i can't find simply on metalink.
I've got one user with a not know password and i want to temporary change
it;s password.
I know it is possible to save the hex-key in dba_users.
But how can i change it back to that hex-key?
I need temporary this user acc
