Stored Procedures

Asked

Viewed 49 times

2

I have a Mysql database with several stored procedures, like releasing only one for a particular user?

I have a database Mysql with several stored procedures, how to release only one for a specific user?

I’m using Phpmyadmin. In user privileges, if I check the EXECUTE option, it frees access to all BD procedures. I need to release only one trial for a particular user. I don’t want him to see the other procedures.

Phpmyadmin executes the following command when setting the EXECUTE option :

GRANT EXECUTE ON `db\_mdm`.* TO 'mdm_user'@'%';

I have tried to replace * with the Procedure name, but to no avail.

GRANT EXECUTE ON `db\_mdm`.`minha_procedure` TO 'mdm_user'@'%';

With tables and views I can restrict what this user can see or do. I would like to do the same thing with stored procedures.

  • 1

    Consecrated, we need more details, edit the question and inserts excerpts of what you have tried to do!

  • Edited Jonathan! Help me aeh...rsrs

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.