SQL Server Audit Action Group: APPLICATION_ROLE_CHANGE_PASSWORD_GROUP

Available in New to:
Database
Audit
Specification
Server
Audit
Specification
2012 2016
• (SQL 2012)  

This group tracks both successful and failed attempts to change the password of application roles.

Application roles are a database principle used to grant a given application-specific access to the database. Although called roles they have no members; they're really closer to a type of user. To track other changes to application roles such as creation and deletion see DATABASE_PRINCIPAL_CHANGE_GROUP.

If you enable this group on a given database you will audit password change attempts on all application roles on just that database; if you enable this group at the server level you'll track password change attempts on all application roles in all databases on the server.

LOGbinder for SQL Server events generated under this Audit Action Group:

Event ID Description
24014 Change application role password succeeded
24015 Change application role password failed

 

Upcoming Webinars
    Additional Resources