How to lock / unlock oracle database user account

0
(0)

To unlock a user Run the following sql as administrator user like SYS or SYSTEM

ALTER USER username IDENTIFIED BY 'password' ACCOUNT UNLOCK;

Lock user:

ALTER USER username ACCOUNT LOCK;

Similar Posts:

1,382

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Scroll to Top