ADM_SYS_PRIVS

ADM_SYS_PRIVS displays information about system permissions granted to users and roles. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_SYS_PRIVS columns
Name	Type	Description
grantee	character varying(128)	Name of the user or role to which the permission is granted.
privilege	character varying(40)	System permissions or ANY permissions of the user. System permissions include rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcatupdate, rolcanlogin, rolreplication, rolauditadmin, rolsystemadmin, roluseft, rolmonitoradmin, roloperatoradmin, and rolpolicyadmin. For details about the value of the ANY permissions, see Table 1.
admin_option	character varying(3)	Specifies whether the grant contains the ADMIN option. YES NO
common	character varying(3)	Not supported. Its value is NULL.
inherited	character varying(3)	Not supported. Its value is NULL.