ROLES
Contains the names of all roles the user can access, along with any roles that have been assigned to those roles.
You can also use the function HAS_ROLE to see if a role is available to a user.
Column Name | Data Type | Description |
---|---|---|
ASSIGNED_ROLES
|
VARCHAR |
The names of any roles that have been granted to this role. By enabling the role, the user also has access to the privileges of these additional roles. If you see an asterisk in the |
NAME
|
VARCHAR |
The name of a role that the user can access. |
ROLE_ID
|
INTEGER |
Catalog-assigned integer value that uniquely identifies the role. |
LDAP_DN |
VARCHAR |
Indicates whether or not the Vertica Analytic Database role maps to an LDAP Link group. When the column is set to dn , the Vertica role maps to LDAP Link. |
LDAP_URI_HASH |
VARCHAR |
The URI hash number for the LDAP role. |
IS_ORPHANED_FROM_LDAP |
VARCHAR |
Indicates if the role is disconnected (orphaned) from LDAP, valid values are: t - role is orphaned f - role is not orphaned For more information see Troubleshooting LDAP Link Issues |