Updated on 2025-02-27 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 SYSADMIN can access this view. This view exists in both the PG_CATALOG and SYS schemas.

Table 1 DB_USERS columns

Name

Type

Description

user_id

oid

OID of a user.

username

name

Username.