Snippet Name: USERS: Lock and Unlock accounts
Description: Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc.
Also see: » USER: connection information
» USER: User Information 2
» USER idle time
» USER Information
» USER active connected users
» USER memory use
» USER: Connected Users
» USER: drop user
» USER: misc queries and commands
» USER system authentication
» USER lock account
» USER password expiration
» USER profile
» USER tablespace quota
» USER temp tablespace
» USER tablespace
» USER password
» USERS: view specific user info
» USERS: view currently connected users
» USERS: view all active users
» USERS: Drop users
» USERS: Proxy Users
» USERS: Grant tablespace access
» USERS: Alter a user
» USERS: CREATE USER w/ authentication
» USERS: Creating Users
» CREATE USER
» Drop User example
» Create User example
» Create User
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 09th, 2009
|
-- lock an account:
ALTER USER <user_name> ACCOUNT LOCK;
-- unlock an account:
ALTER USER <user_name> ACCOUNT UNLOCK;
-- for example:
ALTER USER mike ACCOUNT LOCK;
ALTER USER mike ACCOUNT UNLOCK;
-- force user 'mike' to choose a new password
ALTER USER mike PASSWORD EXPIRE; |