Privileges

Privileges, also referred to as grants, are used to enforce security. Privileges are assigned with a GRANT statement to allow access to database objects and to define what the user is authorized to do with the database object. The REVOKE statement is used to remove privileges.

Privileges can be aggregated into ROLES to make it easy to GRANT a common set of privileges to a number of users.

Different versions of MariaDB Enterprise Server may have different grants. See the All Versions Comparison Table.

For a comparison of changes made to privileges between MariaDB Enterprise Server 10.4 and MariaDB Enterprise Server 10.5, see What's New in MariaDB Server 10.5.

Examples

To grant the ALTER privilege on the example-table to test@192.0.2.0/24:

GRANT ALTER ON example-database.example-table
TO test@192.0.2.0/24;

To remove the ALTER privilege from test@192.0.2.0/24:

REVOKE ALTER ON example-database.example-table
TO test@192.0.2.0/24;