Geek Answers Handbook

Does the user executing the stored procedure containing the delete request execute the delete permission?

Or should they be provided to remove a record from the table only when executing a query that is not a stored procedure?

+7
source share
1 answer

Does the user who is executing the stored procedure containing the delete request require permission to delete?

No, and this is one of the reasons why you can abstract such operations into a stored procedure. All user needs are EXEC permission provided in the stored procedure. This is because the author of the stored procedure suggested that he allowed only valid cases of deleting records from the table.

they need to be allowed to delete a record from the table only when they execute a query that is not a stored procedure.

That's right, they need DELETE permissions in the table to delete a record using the DELETE DML operation.

+7
source

More articles:


All Articles