Oracle Script - List of Locked Users

The following SQL script will list out all users with its status:

SELECT username, account_status
FROM dba_users;

Comments

Post a Comment

Popular posts from this blog

Reports Builder wont open in Windows 10 64bit - [SOLVED]

csv Data to Rows - SQL

Your session has expired - For Custom Apps after Oracle Apex Upgrade from 5 to 20