The SYSAUTHLOG Table [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== The SYSAUTHLOG Table ======

SYSAUTHLOG is the table where all the journaled log entries are maintained.  Log File settings are maintained in the Policy Configuration window.  These settings include enabling or disabling the Auto Clear of the log feature and, if Auto Clear is enabled, the maximum number of entries and the maximum age in days of log entries to permit.  Please see the Policy Configuration Window elsewhere in this document.

 

===== The SYSAUTHLOG Dictionary =====


 

^Column Name^Type^Pos^S/M^DataType^Just^Len^Heading^                             
|ACTION|F|0*3|S|VARCHAR(255)|L|20|Action|
|APPLICATION|F|0*1|S|VARCHAR(255)|L|20|Application|
|CREATED|F|0*2|S|DATETIME|R|21|Created|
|ID|F|0*0|S|VARCHAR(255)|L|20|Id|
|RESULT|F|1|S|VARCHAR(255)|L|20|Result|
|COMMENTS|F|2|S|VARCHAR(255)|L|20|Comments|
|USERNAME|F|3|S|VARCHAR(255)|L|20|Username|
|CURRENT_RTI_AUTH_USER|F|4|S|VARCHAR(255)|L|20|Current Logged In RTI_AUTH User Name|

 

In addition, a BTREE index must be created on the “CREATED” column so that the Auto Clear feature, if enabled, can properly select and clear SYSAUTHLOG rows.