Unlock Oracle user

[chuanye]

Dear all,
Currently if we were to unlock an Oracle user account, we need to login to SQLPLUS but this will disclose password to the users.
How can we unlock an user account but without giving away the password?
Thanks in advance.

Kind regards
cy

 

[Thargy]

This is incorrect.

I can log in to an oracle database using SQL plus remotely, unlock an account, and then log off.

Why does your logging in reveal a password?

Regards

T

 

[chuanye]

Hi T,
The database is offline, which means we are not able to connect to the database remotely. Hence, we had to teach end user on how to unlock the user account themselves.

Kind regards
cy

 

[SantaMufasa]

Chuanye,
Along with Thargy, I'm puzzled, as well. When the user connects locally to SQL*Plus, here is a login scenario:

C:\MSANTA\N>sqlplus

SQL*Plus: Release 9.2.0.8.0 - Production on Sat Aug 27 09:07:46 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: MSANTA
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production


Session altered.


PL/SQL procedure successfully completed.

09:07:56 WM-SANTAML/MSANTA:MSANTA SQL>

I have not obscured or changed anything from my login. True, the administrator connecting does log in with a password that doesn't show, but that is typical.

Another method of logging in as an administrator with using a password is to make the user a member of the Oracle Admin group. At that point, the person connecting can log into SQL*Plus in this fashion:

09:12:31 SQL> conn / as sysdba
Connected.

But perhaps Thargy and I might be missing a point with your question. Please correct us if that is the case.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[chuanye]

Hi Mufasa,
Very sorry as I am not good in Oracle, I tried using connect using: sqlplus "sys as sysdba" and it works.

Thank you very much.

Kind regards
cy