历史版本。 PostgreSQL 9.2 已结束支持。 2017-11-09. 请参阅 当前版本手册.
45.61. pg_roles #
视图pg_roles提供数据库角色的信息。它本质上是
pg_authid 的公开可读视图，并隐藏密码字段。
此视图显式显示底层表的 OID 列，因为与其他目录连接时需要此列。
表 45.62. pg_roles 列
| Name | Type | References | Description |
|---|---|---|---|
rolname | name | Role name | |
rolsuper | bool | Role has superuser privileges | |
rolinherit | bool | Role automatically inherits privileges of roles it is a member of | |
rolcreaterole | bool | Role can create more roles | |
rolcreatedb | bool | Role can create databases | |
rolcatupdate | bool | Role can update system catalogs directly. (Even a superuser cannot do this unless this column is true) | |
rolcanlogin | bool | Role can log in. That is, this role can be given as the initial session authorization identifier | |
rolreplication | bool | Role is a replication role. That is, this role can initiate streaming
replication (see 第 25.2.5 节) and set/unset
the system backup mode using pg_start_backup and
pg_stop_backup
| |
rolconnlimit | int4 | For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. | |
rolpassword | text | Not the password (always reads as ********) | |
rolvaliduntil | timestamptz | Password expiry time (only used for password authentication); null if no expiration | |
rolconfig | text[] | Role-specific defaults for run-time configuration variables | |
oid | oid | | ID of role |