READ_ONLY ADMIN Privilege
Topics on This Page:
- In 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.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_ONLY ADMIN is a synonym for READ ONLY ADMIN.
CHANGE HISTORY
Release Series |
History |
|---|---|
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.