ROLES
Contains the names of all roles the user can access, along with any roles that have been assigned to those roles.
Contains the names of all roles the user can access, along with any roles that have been assigned to those roles.
Tip
You can also use the functionHAS_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. NoteAn 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 therole. |
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 |