How can i grant execute on a prepared statment to an user?

I have to execute a prepared statment in workbench, logining as an user who doesn’t have privileges:

EXECUTE PreparedStatmentName USING @a, @b;

I have tried:

GRANT EXECUTE ON PreparedStatmentName TO 'User';

But it is an “Illegal GRANT/REVOKE command.”

(Sorry for my bad english)

Contents hide

Answers:

Method 1

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

The EXECUTE privilege is actually for executing stored procedures, not prepared statements.

No privilege is needed to PREPARE or EXECUTE an SQL statement, besides the privileges required by that SQL statement itself.

In other words, if the user has SELECT privilege on a given table, then that user can run an SQL query to do that SELECT, whether they run the SELECT directly or by using PREPARE and EXECUTE.

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating