Execute Procedure with caller rights

I created several procedures on a table with simple select statement. then I revoked the access for the user who created the procedure.

When I try to call it with the application user, It gives me error stating that user does not have the correct permission mentioning the username of the procedure creator.

note that the application user has all the select and execute rights for this procedure.


MemSQL implements a “definer” model of permissions for stored procedures. The SP code runs as the user who defined it, for permissions checking purposes. So this is by design. You should make sure that the user who created the SP exists and has the permissions needed by callers of the procedure to do whatever it needs to do.