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.
To grant the
ALTER privilege on the
GRANT ALTER ON example-database.example-table TO firstname.lastname@example.org/24;
To remove the
ALTER privilege from
REVOKE ALTER ON example-database.example-table TO email@example.com/24;