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
commit 7bb509ae808a0b7127e21ffc4539ca7c5568c07b
parent 0cfe068d65b1c1b92ac02993ac0d2a8fd2fc6591
Author: root <root>
Date:   Sat,  7 Sep 2024 22:00:55 +0200

rename file with typo

Diffstat:

Asql/snippets/check_sp_privs.sql | 1+


1 file changed, 1 insertion(+), 0 deletions(-)

diff --git a/sql/snippets/check_sp_privs.sql b/sql/snippets/check_sp_privs.sql
@@ -0,0 +1 @@
+SELECT CONCAT('GRANT EXECUTE ON PROCEDURE ', db, '.', routine_name, ' TO ', '\'', user '\'', '@', '\'', host '\'', ';') FROM mysql.procs_priv WHERE routine_name = 'some_stored_proc';