SQL Server Audit Log Event ID 24189
24189: Revoke database permissions with grant succeeded (action_id RWG class_type DB)
This is an event from
SQL Server
audit event from
LOGbinder SQL
generated by
.
On this page
Permissions to a database were revoked successfully, including ability to grant permissions
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 |
| Target object | |
| | Name | Target object name |
| | Permission bitmask | Target object permission bitmask |
| Statement | Transact-SQL statement |
Setup PowerShell Audit Log Forwarding in 4 Minutes
This Event Is Produced By
Which Integrates with Your SIEM
Revoke database permissions with grant succeeded
Permissions to a database were revoked successfully, including ability to grant permissions
Action Group: DATABASE_PERMISSION_CHANGE_GROUP
Occurred: 8/22/2013 6:07:51.0000000 PM
Session ID: 67
User: LB\Administrator
Server: DEV3
Database: TestDatabase
Target Object
Name: TestUser1
Permission bitmask: System.Byte[]
Statement: REVOKE GRANT OPTION FOR CREATE VIEW FROM TestUser1 CASCADE;; -- 24190: Revoke database permissions with grant failed
For more information, see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=24189
Top 10 Windows Security Events to Monitor
Free Tool for Windows Event Collection