Home » RDBMS Server » Security » how to unlock an account
how to unlock an account [message #115357] Sun, 10 April 2005 13:29 Go to next message
ravivkumar
Messages: 34
Registered: April 2005
Location: chennai
Member

hi
how to unlock an account.
eg: hr user is locked, how to release the lock and use the user.

bye.
Re: how to unlock an account [message #115360 is a reply to message #115357] Sun, 10 April 2005 13:43 Go to previous messageGo to next message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
Try:
ALTER USER hr ACCOUNT UNLOCK;


Best regards.

Frank
Re: how to unlock an account [message #142232 is a reply to message #115360] Thu, 13 October 2005 20:30 Go to previous message
rich.staggs@emotors.com
Messages: 2
Registered: October 2005
Location: St. Louis MO
Junior Member

can also use this script as APPS to unlock the account:
update applsys.fnd_user
set end_date = NULL
where user_name = 'user_name';

Been there learned this...
Previous Topic: Security of SYS AS SYSDBA password
Next Topic: Audit Responsibilities
Goto Forum:
  


Current Time: Wed Sep 22 13:28:01 CDT 2021