Updated on 2024-05-07 GMT+08:00

DB_USERS

DB_USERS displays all users of the database visible to the current user. However, it does not describe the users. By default, only the system administrator can access this view. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_USERS columns

Name

Type

Description

user_id

oid

OID of a user

username

name

Username