Skip to content

Instantly share code, notes, and snippets.

@daemswibowo

daemswibowo/assignRoleToUser.sql

Last active June 12, 2022 09:24
Show Gist options
  • Save daemswibowo/832292a872cfe650c7b7394f122edd80 to your computer and use it in GitHub Desktop.
Save daemswibowo/832292a872cfe650c7b7394f122edd80 to your computer and use it in GitHub Desktop.
Download ZIP
MariaDB ACL
Raw
assignRoleToUser.sql
-- first, we need to grant user to access qateam role
GRANT qateam TO tester@'%';
-- then we assign it
SET ROLE qateam;
-- check if role access already granted to related user
SHOW GRANTS for tester@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment