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

3 votes354 views1 answer
Oracle revoke
SQL
7 votes326 views1 answer
Mysql load data infile csv
SQL
1 vote360 views1 answer
Sql eliminare un record
SQL
0 vote351 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote363 views1 answer
Python mysql query to dataframe
SQL
5 votes355 views2 answers
Mysql date greater than 30 days
SQL
0 vote371 views1 answer
Compare two tables to find unmatched records
SQL
4 votes386 views2 answers
Mysql delete user if exists
SQL
0 vote431 views1 answer
Delete hangfire retries list
SQL
0 vote411 views1 answer
Look at running processes redshift
SQL