This content has been marked as final. Show 2 replies
You can do this by means of a SQL UDM (user-defined metric).
- Create a SQL UDM (two column) for the database target of interest using a query on table dba_users. The following example query will return the users whose accounts are locked and expired & locked.
SELECT username, account_status FROM dba_users WHERE account_status LIKE '%LOCKED';
- Set warning threshold as follows:
Comparison Operator: CONTAINS
- Create a notification rule for the UDM and select to subscribe to "Send E-mail"
For more information on SQL UDMs see: