Timeline for GRANT EXECUTE ON PROCEDURE unable to USE database
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 7, 2015 at 19:54 | comment | added | codemonkee | Suggestion #2 would require me to grant select to the invoker anyways on the table being selected which would allow them to USE the database anyways which then I could just leave it as the DEFINER. Thank you for the feedback. | |
| Aug 7, 2015 at 19:53 | comment | added | codemonkee | Suggestion #1 doesn't seem sensible to me, it would require granting execute permission to all procedures within the DB and then modifying each stored procedure with that logic plus any other users you wanted to prevent from running it. | |
| Aug 7, 2015 at 18:40 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |