A. System Catalogs : Standard Catalog Interface : Standard Catalogs for iidbdb : iiaudit Catalog
 
Share this page                  
iiaudit Catalog
The iiaudit catalog provides the information from which a user (with security privilege) can read the security audit log. This catalog is a read-only virtual representation of the underlying non-Ingres table.
For information on reading the audit log, see the Security Guide.
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