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

1 vote387 views2 answers
Maximum number of tables in mysql
SQL
1 vote379 views2 answers
Sql server find all foreign keys that reference a column
SQL
5 votes334 views2 answers
Oracle tables with column name
SQL
0 vote371 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote372 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote315 views1 answer
How to get last client id sql
SQL
0 vote355 views1 answer
How to define a save method in ruby for sql databases
SQL
10 votes344 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote369 views1 answer
One table with another
SQL
0 vote350 views2 answers
How to know the character set of an oracle databes
SQL