# mysql.roles\_mapping Table

{% hint style="danger" %}
**System tables should not normally be edited directly. Use the related SQL statements instead.**
{% endhint %}

The `mysql.roles_mapping` table contains information about mariaDB [roles](../../../security/user-account-management/roles).

This table uses the [Aria](../../../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](../../sql-statements/account-management-sql-statements/create-role) WITH ADMIN clause). |

The [Acl\_role\_grants](../../../../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" %}
