Syntax to remove the privilege of a user from a stored procedure?

Navigation
0

On the MySQL command line I gave a user permission to access a stored procedure (Stored procedure) with the following syntax: 

GRANT EXECUTE ON PROCEDURE Acervo_bibliografico.InsertarDatoUsuario 
              TO 'Brandon_Padilla'@'localhost';

Now I want to remove the privilege but I do not know what syntax to use. How would it be done?

The database is: Acervo_bibliografico and the stored procedure is InsertarDatoUsuario .

    
asked by Erick Robledo 21.05.2017 в 02:18
source

1 answer

0

Many thanks to those who saw my question, I was inserting various combinations in the command line and at the end I found the answer, the syntax is: 

REVOKE EXECUTE ON PROCEDURE InsertarDatoUsuario FROM 'Brandon_Padilla'@'localhost';

Greetings and Thanks !!

    
answered by 21.05.2017 в 02:43
Text below checkbox Check for words with Latin letters in the string