Skip to content

Instantly share code, notes, and snippets.

@thewellington

thewellington/account_status.sql

Last active December 25, 2015 04:49
Show Gist options
  • Save thewellington/6920430 to your computer and use it in GitHub Desktop.
Save thewellington/6920430 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle: Whose password have expired?
Raw
account_status.sql
/* shows the account status of every user */
select username, account_status, expiry_date, sysdate, profile from dba_users;
/* shows the account status of a specific user */
select username, account_status, expiry_date, sysdate, profile from dba_users where username='username'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment