# 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/accessing-the-information-schema.md) for more information.

***

Modified at: May 11, 2026

Source: [/db/v9.1/reference/information-schema-reference/resource-and-user-management/roles/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/roles/)

(An index of the documentation is available at /llms.txt)