References to Progress Documentation:"If you want the user login session recorded in an OpenEdge RDBMS, you must select the Record Authenticated Client Sessions option in the Database Options dialog box of the Data Administration tool or the character-mode Data Dictionary. With client session recording enabled, for each user login session that you successfully start, OpenEdge generates a single
_client-session record keyed on the user login session ID.
Note: The user login session ID, which uniquely identifies a user login session, is different from any user identity established for the session using a client-principal. Multiple unique user login session records can exist for the same user identity, whether the it is a session identity or a database connection identity.
The contents of this record come from selected attributes of the client-principal object handle, selected ABL session attributes, and, if auditing is enabled, values derived from active audit policy data. For more information on the _client-session table and relevant audit policy data, see OpenEdge Getting Started: Core Business Services - Security and Auditing.
Note: If the database is also audit-enabled, the recorded user login session ID identifies an audit event context used to record several user login session audit events. For more information on using audit event context, see
Auditing."
Example:user2 is configured in _user table
PSCUser is OS log on user, authenticated through _oslocal
Connection ID and session ID both will be recorded:Connection ID is user2
"6+au/ZPImZNTFIq5YAGntQ" "4GLCLIENT" "user2" 2019-05-30T15:07:03.000-04:00 "" "_oeusertable" "" "7RDfBfV1KKAiFGD4vP9NrQ" "" 0 ?
Session ID is PSCUser@local
"6+au/ZPImZNTFIu5iJpRIQ==" "4GLCLIENT" "PSCUser" 2019-05-30T15:07:12.000-04:00 "" "_oslocal" "local" "7RDfBfV1KKAiFGD4vP9NrQ" "" 0 ?
Connection ID and session Id both will be recorded, even if both are the same user account:Connection ID is PSCUser@local
"6+au/ZPImZNTFJO5oNrMbQ" "4GLCLIENT" "PSCUser" 2019-05-30T15:10:10.000-04:00 "" "_oslocal" "local" "7RDfBfV1KKAiFGD4vP9NrQ" "" 0 ?
Session ID is PSCUser@local
"6+au/ZPImZNTFJO5LG7A+g==" "4GLCLIENT" "PSCUser" 2019-05-30T15:10:22.000-04:00 "" "_oslocal" "local" "7RDfBfV1KKAiFGD4vP9NrQ" "" 0 ?
