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. An asterisk (*) appended to a role in this column indicates that the user can grant the role to other users. |
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 |