[MariaDB; 마리아디비] SUPER 권한 / 슈퍼 권한 부여하기

사진: Unsplash 의 Wesley Tingey

SUPER Privilege

GRANT

GRANT SUPER
  ON *.*
  TO 'USERNAME'@'HOSTNAME';

REVOKE

REVOKE SUPER
  ON *.*
  FROM 'USERNAME'@'HOSTNAME';

SHOW Output

SHOW GRANTS FOR 'app_user'@'192.0.2.%';
+----------------------------------------------+
| Grants for app_user@192.0.2.%                |
+----------------------------------------------+
| GRANT SUPER ON *.* TO 'app_user'@'192.0.2.%' |
+----------------------------------------------+

[reference]

https://mariadb.com/docs/skysql-dbaas/ref/xpand/privileges/SUPER/

Open Source Database (RDBMS) for the Enterprise | MariaDB