READ_ONLY ADMIN Privilege
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: Privileges
Topics on this page:
Overview
In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS:
Grants ability to START TRANSACTION (special cases), INSERT (special cases), UPDATE (special cases), DELETE (special cases), DROP TRIGGER (special cases), SET (some variables only). Added in MariaDB Enterprise Server 10.5 as fine-grained SUPER privilege to reduce the dependency on SUPER. Prior to this version this will have been part of SUPER.
In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
See also: Privileges in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
Grants ability to START TRANSACTION (special cases), INSERT (special cases), UPDATE (special cases), DELETE (special cases), DROP TRIGGER (special cases), SET (some variables only). Added in MariaDB Enterprise Server 10.5 as fine-grained SUPER privilege to reduce the dependency on SUPER. Prior to this version this will have been part of SUPER.
Allows the user to write data even if the read_
only system variable is enabled.Allows the user to execute DROP TRIGGER statements even if the read_
only system variable is enabled.Allows the user to execute START TRANSACTION READ WRITE statements even if the read_
only system variable is enabled.Allows the user to set system variables read_
only .
READ_
CHANGE HISTORY
Release Series | History |
|---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Information specific to MariaDB SkySQL can be found on the READ_
ONLY ADMIN page in the SkySQL Documentation .