All-Permission users cannot execute stored procedures

When using a stored procedure, we usually only need to grant the corresponding permissions to the account that calls the stored procedure. However, in fact, the stored procedure defines whether the user can directly execute the stored procedure, if you do not know this

When using a stored procedure, we usually only need to grant the corresponding permissions to the account that calls the stored procedure. However, in fact, the stored procedure defines whether the user can directly execute the stored procedure, if you do not know this

When using stored procedures, we usually only need to grant the corresponding permissions to the account that calls the stored procedures. Hong Kong servers, but in fact, the stored procedure defines whether the user can be directly related to the execution of the stored procedure. If you do not know this, even if the account that calls the stored procedure has the storage-related permissions, similarly, stored procedures cannot be executed.

Syntax:

Create definer = 'xx' @ '%' PROCEDURE 'mmm'

This article is from the "soul-picking" blog. Please keep this source