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.
Consecrated, we need more details, edit the question and inserts excerpts of what you have tried to do!
– Jonathan de Toni
Edited Jonathan! Help me aeh...rsrs
– Sergio Almeida de Sousa