In MariaDB, various privileges allow users to perform certain actions. Here are some of them:
1. ALL PRIVILEGES: Grants all privileges to a user account (Except GRANT OPTION and PROXY).
1. CREATE: Allows creation of databases and tables.
1. DROP: Allows deleting of databases, tables, and views.
1. DELETE: Allows deletion of rows from tables.
1. INSERT: Allows inserting of rows into tables.
1. SELECT: Allows querying of data from tables.
1. UPDATE: Allows updating of table rows.
1. ALTER: Allows modification of existing tables.
1. CREATE TEMPORARY TABLES: Allows creation of temporary tables.
1. CREATE VIEW: Allows creation of views.
1. EVENT: Allows to set up events for event scheduler.
1. GRANT OPTION: Allows granting or removing other user’s privileges.
1. INDEX: Allows creating or dropping indexes.
1. LOCK TABLES: Allows locking of tables for the current thread.
1. SHOW VIEW: Allows using of SHOW CREATE VIEW.
1. TRIGGER: Allows creation or deletion of triggers.
1. CREATE ROUTINE and ALTER ROUTINE: Allows creating and altering stored routines.
1. CREATE USER: Allows creating, altering, and dropping user accounts.
1. FILE: Allows importing data from and exporting data into files.
1. PROCESS: Allows viewing of all processes with SHOW PROCESSLIST.
1. RELOAD: Allows use of FLUSH operations.
1. REPLICATION CLIENT: Allows server’s host name and status information.
1. REPLICATION SLAVE: Required for replication slaves.
1. SHOW DATABASES: Shows all databases.
1. SHUTDOWN: Allows shutting down the MariaDB server.
1. SUPER: Allows connecting, even if maximum connections threshold reached, and provides various other privileges.
Please note that assigning privileges should be done cautiously and typically, the principle of least privilege should be followed.
