System privileges in a MySQL tenant

2023-08-15 11:20:54  Updated

This topic describes the system privileges in a MySQL tenant.

System privileges

Privilege Description
ALTER The ALTER TABLE privilege.
CREATE The CREATE TABLE privilege.
DELETE The DELETE privilege.
DROP The DROP privilege.
INSERT The INSERT privilege.
SELECT The SELECT privilege.
UPDATE The UPDATE privilege.
INDEX The CREATE INDEX and DROP INDEX privileges.
CREATE VIEW The privilege to create and delete views.
SHOW VIEW The SHOW CREATE VIEW privilege.
CREATE USER The CREATE USER, DROPUSER, RENAME USER, and REVOKE ALLPRIVILEGES privileges.
PROCESS The PROCESS privilege.
SUPER The SET GLOBAL privilege for modifying global system parameters.
SHOW DATABASES The global SHOW DATABASES privilege.
GRANT OPTION The GRANT OPTION privilege.

Contact Us