Database role member added

How can we help?
< All Topics
Print

Database role member added

Will throw a one-time alert when a user or group is added to a database role.

To query the Performance Store database for the last 100 added database role members, use:

select top 100 a.*
from dbo.v_audit a
where a.event_type = 'ADD_ROLE_MEMBER'
order by a.post_time desc

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents