Skip to content

Instantly share code, notes, and snippets.

@yyoshiki41

yyoshiki41/grant-sql-tmpl.md

Last active September 17, 2020 02:40
Show Gist options
  • Save yyoshiki41/b97456be88f82b2fcb8e6b0470f5eb2a to your computer and use it in GitHub Desktop.
Save yyoshiki41/b97456be88f82b2fcb8e6b0470f5eb2a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
grant-sql-tmpl.md 
# app
GRANT SELECT, INSERT, UPDATE, DELETE ON *.* TO app@'10.255.0.0/255.255.0.0' IDENTIFIED BY 'password'

# operator
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX, REFERENCES ON *.* TO operator@'%' IDENTIFIED BY 'password'

# viewer
GRANT SELECT ON *.* TO viewer@'%' IDENTIFIED BY 'password'

# watcher
GRANT SELECT, PROCESS, SHOW DATABASES, SHOW VIEW ON *.* TO watcher@'10.255.0.0/255.255.255.0' IDENTIFIED BY 'password'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment