W3cubDocs

/MariaDB

Roles

MariaDB starting with 10.0.5

Roles were introduced in MariaDB 10.0.5.

Roles bundle privileges together to ease account management

Title Description
Roles Overview Bundling privileges together.
CREATE ROLE Add new roles.
DROP ROLE Drop a role.
CURRENT_ROLE Current role name.
SET ROLE Enable a role.
SET DEFAULT ROLE Sets a default role for a specified (or current) user.
GRANT Create accounts and set privileges or roles.
REVOKE Remove privileges or roles.
mysql.roles_mapping Table MariaDB roles information
Information Schema APPLICABLE_ROLES Table Roles available to be used.
Information Schema ENABLED_ROLES Table Enabled roles for the current session.
SecuRich Library of security-related stored procedures.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/roles/