Skip to content

Instantly share code, notes, and snippets.

@jbuck

jbuck/fxa_sproc.sql

Created April 18, 2016 19:46
Show Gist options
  • Save jbuck/b3cbf021eecad92f525eb162c2054e66 to your computer and use it in GitHub Desktop.
Save jbuck/b3cbf021eecad92f525eb162c2054e66 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fxa_sproc.sql
CREATE USER 'fxa_sproc_def';
GRANT ALL PRIVILEGES ON fxa.* TO 'fxa_sproc_def';
UPDATE `mysql`.`proc` p SET definer = 'fxa_sproc_def@%' WHERE definer='root@localhost'
CREATE USER 'fxa_user_1';
GRANT EXECUTE ON PROCEDURE fxa.* to 'fxa_user_1';
CREATE USER 'fxa_user_2';
GRANT EXECUTE ON PROCEDURE fxa.* to 'fxa_user_2';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment