SQL Server Audit Log Event ID 24281
24281: Issued select command (action_id SL)
This is an event from
SQL Server
audit event from
LOGbinder SQL
generated by
.
On this page
A select command was issued on a database
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 | |
| Database | Database affected by the event |
| Target object | |
| | ID | Target object ID |
| | Name | Target object name |
| | Type | Target object type |
| Is column permission | Flag indicating a column level permission |
| Permission bitmask | When applicable, shows the permissions that were granted, denied, or revoked |
| Schema | Schema context in which the action occurred |
| Statement | Transact-SQL statement |
Setup PowerShell Audit Log Forwarding in 4 Minutes
This Event Is Produced By
Which Integrates with Your SIEM
Issued select command
A select command was issued on a database
Action Group: Database-level audit actions
Occurred: 9/12/2012 4:51:26.0000000 PM
Authorization result: Access allowed
Session ID: 79
User: SP2010\administrator
Server: SP2010-SQL8
Database: rfstest
Target Object
ID: 2105058535
Name: patients
Type: Table
Is column permission: True
Permission bitmask: 1
Schema: dbo
Statement: select * from rfstest.dbo.patients where test='RFS'
For more information, see http://logbinder.com/support
Top 10 Windows Security Events to Monitor
Free Tool for Windows Event Collection