RE: Disable certain users from login to database while applying H

[Szecsy Tamas]

Title: RE: Disable certain users from login to database while applying H

I agree with using the revoke session solution.

 

All the same you can change a user's password to something else and change it back again without ever knowing what it was:

 

1. select 'alter user scott identified by values '''||password||''';'
                    from dba_users
                    where username = 'SCOTT';

  put away the result

 

2. change the password to something else

 

3. change the password back again to what it was previously:

 

   execute the result of the first point.

 

Regards,

Tamas Szecsy

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 14:03
To: Multiple recipients of list ORACLE-L
Subject: RE: Disable certain users from login to database while applying H

But then how do you know what to change it back to?  I'd steer away from this - head w/ the revoke create session