Page History
...
SQL Compliance Manager allows you to capture the following types of event data depending on your auditing selection.
Event | Trace (.trc) | Extended Events (.xel) | Audit Logs (.audit) |
---|---|---|---|
ApplicationName | Yes | Yes | No |
ColumnPermissions | Yes | No | Yes |
BeforeAfter | Yes | Yes | No |
DatabaseID | Yes | Yes | Yes |
DatabaseName | Yes | Yes | Yes |
DBUserName | Yes | No | Yes |
EventClass | Yes | Yes | Yes |
EventSequence | Yes | - | Yes |
EventSubClass | Yes | Yes | Yes |
FileName | Yes | No | Yes |
HostName | Yes | Yes | No |
IsSystem | Yes | Yes | No |
LinkedServerName | Yes | No | No |
LoginName | Yes | Yes | Yes |
NestLevel | Yes | Yes | Yes |
ObjectID | Yes | No | Yes |
ObjectName | Yes | No | Yes |
ObjectType | Yes | No | Yes |
OwnerName | Yes | No | No |
ParentName | Yes | No | No |
Permissions | Yes | No | Yes |
ProviderName | Yes | No | No |
RoleName | Yes | No | No |
RowCounts | Yes | Yes | No |
ServerName | Yes | Yes | Yes |
SessionLoginName | Yes | Yes | Yes |
SPID | Yes | Yes | Yes |
StartTime | Yes | Yes | Yes |
Success | Yes | No | Yes |
TargetLoginName | Yes | No | Yes |
TargetUserName | Yes | No | Yes |
TextData | Yes | Yes | Yes |
SQL Compliance Manager Calculated Columns
You can capture different event data by using the different auditing options
at one or more of the following levels:
Event | Trace (.trc) | Extended Events (.xel) | Audit Logs (.audit) |
---|---|---|---|
alertLevel | Yes | Yes | Yes |
appNameId | Yes | Yes | No |
details | Yes | No | Yes |
endSequence | Yes | Yes | Yes |
endTime | Yes | Yes | Yes |
eventCategory | Yes | Yes | Yes |
hash | Yes | Yes | Yes |
hostId | Yes | Yes | No |
loginId | Yes | Yes | Yes |
privilegedUser | Yes | Yes | Yes |
startSequence | Yes | Yes | Yes |
targetObject | Yes | No | Yes |
Scroll pdf ignore |
---|
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
...