Users: Lock And Unlock Accounts

Description: Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc.

-- lock an account:
ALTER USER <user_name> ACCOUNT LOCK;
 
-- unlock an account:
ALTER USER <user_name> ACCOUNT UNLOCK;
 
 
-- for w3mentor:
ALTER USER mike ACCOUNT LOCK;
 
ALTER USER mike ACCOUNT UNLOCK;
 
 
-- force user 'mike' to choose a new password
ALTER USER mike PASSWORD EXPIRE;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.