Product Documentationsys.user
A system view that returns information about the users in the system. See also sys.role.
Superusers can see all users in this view. Users and roles with CREATE ROLE, ALTER ANY ROLE, or DROP ANY ROLE privilege can also see all users in this view.
Users and roles that are not superusers and do not have (or inherit) CREATE ROLE, ALTER ANY ROLE, or DROP ANY ROLE privilege can only see their own accounts in this view.
| Column Name | Data Type | Description |
|---|---|---|
| user_id | bigint | The unique ID for the user or role. |
| name | text | Name of the user or role. |
| search_path | text | Value of the search_path parameter. |
| create_role | boolean | Whether the user can create other users. |
| create_database | boolean | Whether the user can create databases. |
| superuser | boolean | Whether the user has superuser privileges. |
| has_local_password | boolean | true means that the user has a local password set via ALTER USER (or CREATE USER). false means that the user does not have a local password and may depend on an LDAP password for login. |
| ldap_synchronized | boolean | true means that this user exists in the database via LDAP synchronization. |
| memberof | name[] | Roles that the user is a member of. |
Example
premdb=# select * from sys.user where name not like 'sys%' and user_id>16100;
user_id | name | search_path | create_role | create_database | superuser | has_local_password | ldap_synchronized | memberof
---------+----------+-------------+-------------+-----------------+-----------+--------------------+-------------------+----------
16475 | backup2 | [NULL] | f | f | f | t | f | {bar}
16473 | bar | [NULL] | f | f | f | t | f | {}
16387 | ybd_test | [NULL] | f | f | f | t | f | {}
16474 | backup1 | [NULL] | f | f | f | t | f | {bar}
16476 | restore1 | [NULL] | f | f | f | t | f | {bar}
16472 | bobr | [NULL] | t | t | t | t | f | {}
16477 | restore2 | [NULL] | f | f | f | t | f | {bar}
(7 rows)Parent topic:System Views