SUPER Privilege

DETAILS

Starting with Xpand 6.1, permissions for some operations have been split from SUPER to several new privileges:

• The BINLOG ADMIN privilege grants permissions for the following operations:

  • ALTER BINLOG

  • CREATE BINLOG

  • DROP BINLOG

  • SHOW BINLOG POSITION

  • SHOW BINLOG SEGMENTS

  • SHOW BINLOGS

  • TRIM BINLOG

• The CLUSTER ADMIN privilege grants permissions for the following operations:

  • ALTER CLUSTER

  • ALTER SLICE

  • ALTER REPLICA

• The CONNECTION ADMIN privilege grants permissions for the following operations:

  • KILL

• The REPAIR ADMIN privilege grants permissions for the following operations:

  • REPAIR TABLE

• The REPLICATION ADMIN privilege grants permissions for the following operations:

  • CHANGE MASTER TO

  • CHANGE REPLICA

  • CHANGE SLAVE

  • CREATE REPLICA

  • CREATE SLAVE

  • DROP REPLICA

  • DROP SLAVE

  • REPLICA START

  • REPLICA STOP

  • SLAVE START

  • SLAVE STOP

  • START REPLICA

  • START SLAVE

  • STOP REPLICA

  • STOP SLAVE

• The SET USER privilege grants permissions for the following operations:

  • CREATE DEFINER=[<user_name>] PROCEDURE

  • CREATE DEFINER=[<user_name>] TRIGGER

• The SYSTEM VARIABLES ADMIN privilege grants permissions for the following operations:

  • SELECT .. INTO @@global.<var_name>

  • SET GLOBAL <var_name>