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

11 votes288 views1 answer
Oracle insert into where
SQL
0 vote298 views1 answer
Psql get table data types
SQL
0 vote307 views1 answer
How to set up an anonymous function to variable in swift
SQL
-2 votes278 views1 answer
Remove root password mysql
SQL
5 votes290 views1 answer
Oracle sysdate - 1 month
SQL
2 votes244 views1 answer
Latest record in sql
SQL
1 vote360 views1 answer
Sql and
SQL
0 vote297 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
4 votes236 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
3 votes295 views1 answer
Increment integer in table sql
SQL