Dba_profiles
How to Block a User in Oracle Database (ACCOUNT LOCK)
Dec 31, 2023 / · 9 min read · user Oracle account dba_users dba_profiles v$session unified_audit_trail ·Lock or Unlock an Oracle User in the Database Purpose A contractor leaves on Friday. A service account password shows up in a chat log. A batch user fails to log in 40 times from an unknown host. In each case the first move is the same: shut the account without dropping it. ALTER USER ... ACCOUNT LOCK does that. The …
Read More