11. OpenSQL Standard Catalogs : Standard Catalog Interface : The iisecurity_alarms Catalog
 
Share this page                  
The iisecurity_alarms Catalog
The iisecurity_alarms catalog contains information about the security alarms created on tables in the database. This catalog is a view of security alarm information held in the system iiprotect table.
Column Name
Data Type
Description
alarm_name
char(32)
The name of the security alarm
object_name
char(256)
The name of the table to which the security alarm applies
object_owner
char(32)
The owner of the security alarm
object_type
char(1)
The type of object to which the security alarm applies
Always T
create_date
char(25)
The date the security alarm was created
subject_type
char(1)
U if the security_user is a user
G if a group
R if a role
P if a public identifier
security_user
char(32)
The user to which the security alarm applies
security_number
smallint
The security alarm number
dbevent_name
char(32)
Database event associated with the alarm
dbevent_owner
char(32)
Owner of the database event
dbevent_text
char(256)
Text of the database event
text_sequence
integer8
The sequence number from 1 for the text_segment
text_segment
varchar(240)
The text of the security alarm statement definition