Updated on 2025-05-29 GMT+08:00

USER_LOGIN

USER_LOGIN records the number of user logins and logouts, as described in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

Table 1 USER_LOGIN columns

Name

Type

Description

node_name

text

Node name.

user_name

text

Username.

user_id

integer

User OID (Its value is the same as that of oid in pg_authid.)

login_counter

bigint

Number of logins.

logout_counter

bigint

Number of logouts.

dbid

oid

ID of the database to which the user logs in.