_progress._Client-Session

This table records a client authenticated session information. It stores information about the client session and the methods used to authenticate the client. Its primary purpose is to provide additional information for auditing for the purposes of non repudiation, i.e. to provide extra information as to exactly who the user was. This table is part of a blank empty database as it has other uses beyond auditing. When used for auditing, the client session UUID will be used to associate the authenticated client session with the audit events. An authenticated client session may not always be available when recording auditing events, e.g. in the case of an appserver connecting to a database outside of the context of an authenticated session. The data in this table can be sealed with a Message Digest or MAC for non-repudiation. Note that the data in this table must be copied to the archive database as part of the archive process, but the contents will not be deleted as part of the same process as the client session information could be used for other purposes than auditing.


Table details

Area Schema Area
Dumpname ?
Label ?
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
11 _Audit-data-security-level X Audit data security level integer ->9 0 D: This field is copied from the _Audit-data-security-level field on the _aud-audit-policy and records the data integrity (seal) type for this record. The value of this field determines what information is written to the _Data-seal field at record creation time.
5 _Authentication-date-time X Authentication date/time datetime-tz 99/99/9999 HH:MM:SS.SSS+HH:MM ? D: The authentication date and time.
8 _Authentication-domain-name X Authentication domain name character X(70) D: The application alias or logical name depending on the domain type or authentication plug-in being used, e.g. for LDAP it would be an LDAP domain such as App1LDAP.
7 _Authentication-domain-type X Authentication domain type character X(35) D: The type of authentication plug-in used, e.g. LDAP.
3 _Client-name X Client name character X(35) D: This is the name of the type of client session, e.g. AS - Appserver WS - WebSpeed 4GL - 4GL Client SQL - SQL Client DBA - Database Admin Tools
2 _Client-session-uuid X Client session uuid character X(28) D: This is a unique id for the client login session and when auditing is used to tie together all the audit data for a specific session.
12 _Data-seal X Data seal character X(28) D: An internally generated seal on the data that guarantees the integrity of the data and ensures it has not been tampered with outside of the registered services permitted to maintain this data. This could be a message digest or a MAC. The use of the data seal is optional as it will guarantee non-repudiation of the data but will have a cost of additional storage space and a possible impact on performance to assign a value / check the results.
9 _Db-guid X Database guid character X(28) D: This is a globally unique identifier (GUID) for the database that this authenticated client session was for / originated in.
6 _Server-uuid X Server uuid character X(28) D: This is the unique id for the connected appserver, webspeed server, etc. to determine exactly which server was used in the case where multiple servers are in operation.
10 _Session-custom-detail X Session custom detail character X(3000) V: e sz 70 BY 8 sv LARGE MAX-CHARS 3000
D: User defined session information - free text, e.g. terminal id.
4 _User-id X User id character X(35) D: This is the id of the authenticated user.

Indexes

Index name Flags Fields Datatype
_Session-uuid P U _Client-session-uuid (+) character
_Auth-time _Authentication-date-time (+) datetime-tz
_Db-guid _Db-guid (+) character
_Userid _User-id (+) character
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

generated 3-3-2025 10:54