SQL Server Audit Log Event ID 24020
24020: Add member to database role succeeded (action_id APRL class_type RL)
This is an event from
SQL Server
audit event from
LOGbinder SQL
generated by
.
On this page
A principal was successfully added to a database role
Free Security Log Resources by Randy
Field | Description |
Occurred | When event was reported by SQL Server |
Session ID | ID of the session on which the event occurred |
User | |
Server | |
Database | Database affected by the event |
Member | Member added or removed |
| Name | Name of member added or removed |
| Domain name | Domain of the member added/removed |
Role | |
| ID | ID of the role affected by this event |
| Name | Name of the role affected by this event |
Statement | Transact-SQL statement |
Supercharger Enterprise
This Event Is Produced By
Which Integrates with Your SIEM
Add member to database role succeeded
A principal was successfully added to a database role
Action Group: DATABASE_ROLE_MEMBER_CHANGE_GROUP
Occurred: 8/22/2013 6:07:51.0000000 PM
Session ID: 67
User: LB\Administrator
Server: DEV3
Database: TestDatabase
Member
Name: TestUser1
Domain name: TestLogin1
Role
ID: 8
Name: TestDBRole
Statement: alter role [TestDBRole] add member [TestUser1]
For more information, see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=24020
Top 10 Windows Security Events to Monitor
Free Tool for Windows Event Collection