Column Name | Data Type | Description |
audittime | date | The time when the security event occurred |
user_name | char(32) | The effective name of the user that triggered the security event |
real_name | char(32) | The real name of the user |
userprivileges | char(32) | Privileges associated with the user session, with letters denoting the possession of a subject privilege |
objprivileges | char(32) | Privileges granted to the user, with letters denoting the possession of a subject privilege |
database | char(32) | The name of the database in which the event was triggered |
auditstatus | char(1) | Y--the attempted operation was successful N--the attempted operation was unsuccessful |
auditevent | char(24) | The type of event: select insert delete update copy into copy from execute modify create destroy security |
objecttype | char(24) | The type of object being accessed: database role procedure table location view security user security alarm rule event |
objectname | char(32) | The name of the object being accessed |
objectowner | char(32) | The owner of the object being accessed |
description | char(80) | The text description of the event |
sessionid | char(16) | The session associated with the event |
detailinfo | char(256) | Detailed information about the event |
detailnum | integer | The sequence number for multiple detail items needed to describe the event |
querytext_sequence | integer | Identifier for associated prepared query |