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 ASSIGNED_ROLES column output, it means the user has roles WITH ADMIN OPTION.

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

See Also