OraFAQ Forum: Security » how to unlock an account

Home » RDBMS Server » Security » how to unlock an account

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to unlock an account [message #115357]

Sun, 10 April 2005 13:29

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.

Report message to a moderator

Re: how to unlock an account [message #115360 is a reply to message #115357]

Sun, 10 April 2005 13:43

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Try:

ALTER USER hr ACCOUNT UNLOCK;

Best regards.

Frank

Report message to a moderator

Re: how to unlock an account [message #142232 is a reply to message #115360]

Thu, 13 October 2005 20:30

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...

Report message to a moderator

Previous Topic:	Security of SYS AS SYSDBA password
Next Topic:	Audit Responsibilities

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 05:03:57 CDT 2024