CONNECTION ADMIN Privilege
Topics on This Page:
- In 10.5 ES, 10.5 CS:
Grants ability to KILL, SET (some variables only). Skips the execution of init_connect when the user connects. Ignores max_connections, max_user_connections, and max_password_errors when the user connects. 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 KILL, SET (some variables only). Added in MariaDB Enterprise Server 10.5 as fine-grained SUPER privilege to reduce the dependency on SUPER. Prior to ES10.5 CONNECTION ADMIN was part of SUPER.
Skips the execution of init_connect when the user connects.
Ignores max_connections when the user connects.
Ignores max_user_connections when the user connects.
Ignores max_password_errors when the user connects.
Allows the user to kill connections owned by other users with the KILL statement.
Allows the user to set system variables:
thread_pool_mode
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 CONNECTION ADMIN page in the SkySQL Documentation.