SQL Server Audit Log Event ID 24178
24178: Issued revoke server object permissions with cascade command (action_id RWC; class_type LX)
This is an event from
SQL Server
audit event from
LOGbinder SQL
generated by
.
On this page
A command to revoke permissions to a server object was issued, including cascade of permissions
Free Security Log Resources by Randy
| Field |
Description |
| Occurred |
When event was reported by SQL Server |
| Authorization result |
If the command passed authorization checks |
| Session ID |
ID of the session on which the event occurred |
| User |
|
| Server |
|
| Target object |
|
| |
ID |
Target object ID |
| |
Name |
Target object name |
| |
Type |
Target object type |
| |
Permission bitmask |
Target object permission bitmask |
| Statement |
Transact-SQL statement |
Supercharger Free Edition
Centrally manage WEC subscriptions.
Free.
This Event Is Produced By
Which Integrates with Your SIEM
Issued revoke server object permissions with cascade command
A command to revoke permissions to a server object was issued, including cascade of permissions
Action Group: SERVER_OBJECT_PERMISSION_CHANGE_GROUP
Occurred: 8/22/2013 6:07:50.0000000 PM
Authorization result: Access allowed
Session ID: 67
User: LB\Administrator
Server: DEV3
Target Object
ID: 272
Name: TestLogin1
Type: SQL login
Permission bitmask: System.Byte[]
Statement: REVOKE IMPERSONATE ON LOGIN::[TestLogin1] TO [TestLogin2] CASCADE AS [TestLogin1]
For more information, see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=24178
Top 10 Windows Security Events to Monitor
Free Tool for Windows Event Collection