# mysql.roles\_mapping Table

1. PARTITION BY SYSTEM\_TIME is not supported for transaction-precise system-versioned tables. Attempting

The `mysql.roles_mapping` table contains information about mariaDB [roles](https://mariadb.com/docs/server/security/user-account-management/roles).

This table uses the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) storage engine.

The `mysql.roles_mapping` table contains the following fields:

| Field         | Type          | Null | Key | Default | Description                                                                                                                                                                        |
| ------------- | ------------- | ---- | --- | ------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Host          | char(60)      | NO   | PRI |         | Host (together with User and Role makes up the unique identifier for this record.                                                                                                  |
| User          | char(80)      | NO   | PRI |         | User (together with Host and Role makes up the unique identifier for this record.                                                                                                  |
| Role          | char(80)      | NO   | PRI |         | Role (together with Host and User makes up the unique identifier for this record.                                                                                                  |
| Admin\_option | enum('N','Y') | NO   |     | N       | Whether the role can be granted (see the [CREATE ROLE](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/create-role) WITH ADMIN clause). |

The [Acl\_role\_grants](https://mariadb.com/docs/server/server-management/variables-and-modes/server-status-variables#acl_role_grants) status variable indicates how many rows the `mysql.roles_mapping` table contains.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}