Roles

Manage roles in MariaDB Server for streamlined user access control. This section explains how to create, assign, and manage roles to simplify privilege management and enhance security.

Roles Overview

Overview of Role-Based Access Control (RBAC) in MariaDB, which simplifies privilege management by allowing permissions to be grouped into roles and assigned to users.

System Users, Roles, Privileges

Details default system users like mariadb.sys and the PUBLIC role, including their creation, purpose, and special management behaviors.

CREATE ROLE

Create new roles to simplify privilege management. Learn how to define a role that can be assigned to multiple users or other roles.

DROP ROLE

Remove a role from the system. Learn the syntax to delete defined roles and revoke them from any users or roles that currently hold them.

CURRENT_ROLE

Returns the current role. The current role can be set with SET ROLE or SET DEFAULT ROLE.

SET ROLE

Sets the current role for the session. Learn how to enable none, or a specific role to change your current privileges dynamically.

SET DEFAULT ROLE

Define the default role for a user. Learn how to configure which role is automatically active when a user connects to the server.

GRANT

Complete privilege management guide for MariaDB. Complete GRANT syntax for database, table, and column permissions with roles with comprehensive examples and.

REVOKE

Remove privileges or roles. Learn how to withdraw previously granted permissions from users or roles to restrict access and secure the database.

mysql.roles_mapping Table

The mysql.roles_mapping table manages role assignments, linking user accounts to the roles they have been granted.

Information Schema APPLICABLE_ROLES Table

The Information Schema APPLICABLE_ROLES table shows the role authorizations that the current user may use, detailing grantable and default status.

Information Schema ENABLED_ROLES Table

The Information Schema ENABLED_ROLES table lists all roles that are currently enabled for the current session, including nested roles.