Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

ROLES

This view is a list of all roles and their properties related to audit permissions or security compliance.

Column Name

Description

ROLE

Name of the role

EFFECTIVE_FAILED_LOGIN_ATTEMPTS

Number of failed login attempts counted for this role (if applicable).

EFFECTIVE_PASSWORD_LOCK_TIME

Current lock time (duration or timestamp) due to failed logins (if applicable).

PERMISSIONS

Set of permissions associated with the role.

Note: Granting the SHOW METADATA permission at the cluster scope provides broad visibility into metadata for all roles, without granting read or write access to those objects. Refer to Accessing the Information Schema for more information.

Last modified:

Was this article helpful?