Oracle list user locked

SELECT * FROM DBA_USERS WHERE ACCOUNT_STATUS <> 'OPEN';
-- Unlock a user
ALTER USER my_user ACCOUNT UNLOCK;
-- If password is expired 
ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;

Similar codes

7 votes288 views1 answer
Sql server convert string to date
SQL
0 vote286 views1 answer
Commit transaction sql
SQL
0 vote229 views1 answer
Denied
SQL
1 vote298 views1 answer
Postgres set column based on another column
SQL
2 votes286 views1 answer
Columns Present in a table
SQL
37 votes461 views3 answers
Sql check duplicate value in column
SQL
4 votes266 views1 answer
Postgresql show current database
SQL
11 votes269 views2 answers
Sql rank
SQL
0 vote300 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote261 views1 answer
Sql from null to not null
SQL