PPM_LOGON_SESSIONS

This table stores information about the sessions created on the PPM server. It includes information such as session start and end time, session type, how uses logged on to PPM, PPM node on which the session was created, and how the session ended.

This table can be used in combination with KNTA_LOGON_ATTEMPTS for user sessions tracking. For example, if you want to find out the IP address of a user when connecting to PPM, you can refer to the table KNTA_LOGON_ATTEMPTS.

Foreign Keys

There are no foreign keys for this table.

Column Descriptions

Column Name

Null?

Data Type

Description
LOGON_SESSION_ID NOT NULL NUMBER System-generated identifier of the session.
USER_ID NULLABLE NUMBER Identifier for the user who tried to connect
USERNAME NULLABLE VARCHAR2 (200) Username of the user who tried to connect
NODE_NAME NULLABLE VARCHAR2 (512) PPM node on which the session was created.
SESSION_START_TIME NULLABLE DATE Session start time
SESSION_FINISH_TIME NULLABLE DATE Session finish time
SESSION_TYPE NULLABLE VARCHAR2 (40)

Session type. Available values are:

  • Web
  • Workbench
  • MSP_PLUGIN
AUTHENTICATION_TYPE NULLABLE VARCHAR2 (30)

Authentication type used to log on to PPM. Available values are:

  • USERNAME_PASSWORD
  • SITEMINDER
  • SSO
  • NTLM
  • ONE_TIME_KEY
  • LW_SSO
  • COOKIE
SESSION_END_CAUSE NULLABLE VARCHAR2 (50)

How the session ended. Available values are:

  • SIGN_OUT
  • SESSION_TIMEOUT
  • SERVER_GRACEFUL_SHUTDOWN
  • SERVER_UNEXPECTED_SHUTDOWN
  • NEW_SESSION_CREATED

Note: If the server crashes, SESSION_FINISH_TIME and SESSION_END_CAUSE will be empty for the ended sessions. Only when the server gets restarted, SESSION_END_CAUSE will be updated to SERVER_UNEXPECTED_SHUTDOWN, and SESSION_FINISH_TIME will be updated to the time when the server got restarted, not the time when the server crashed.

Indexes

Index Name Index Type Sequence Column Name
SYS_C0040609 UNIQUE 1 LOGON_SESSION_ID
PPM_LOGON_SESSIONS_N1 NONUNIQUE 1 SESSION_START_TIME
PPM_LOGON_SESSIONS_N1 NONUNIQUE 2 SESSION_FINISH_TIME, NODE_NAME
PPM_LOGON_SESSIONS_N3 NONUNIQUE 1 USER_ID

Sequences

Sequence Name Sequence Type
PPM_LOGON_SESSIONS_S LOGON_SESSION_ID