Back (Current repo: scraps)

random scraps and notes that are useful to me
To clone this repository:
git clone https://git.viktor1993.net/scraps.git
Log | Download | Files | Refs

check_sp_privs.sql (183B)

SELECT CONCAT('GRANT EXECUTE ON PROCEDURE ', db, '.', routine_name, ' TO ', '\'', user '\'', '@', '\'', host '\'', ';') FROM mysql.procs_priv WHERE routine_name = 'some_stored_proc';