
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-18-2017 12:52 PM
I am trying to determine if there is a way to either report on (or trigger an Email notification for) users that have failed to log in a set number of times, and are thus locked out.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-18-2017 12:57 PM
Sure thing Russell. Create an email notification on the User table whenever 'locked out' 'changes to' 'true'. You can email the users manager, the users email on their account, etc.
There are system properties that control the # of failed attempts for lockout, found here: Specify lockout for failed login attempts

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2017 11:22 AM
Ahh got it.
The only similar concept top of mind would be enabling auditing on the user table and then searching sys_history_set for updates to the 'locked out' field.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2017 12:51 PM
That sounds like another good potential solution, thanks Darius!