Granting Privileges on Stored Procedures

How To

You must have the execute privilege for a stored procedure to execute it. In order to allow a stored procedure to be used by others, you can grant execute privilege on a stored procedure to other database users. If you do not wish others to execute a stored procedure, you can revoke execute privilege of the stored procedure from them. However, you can only grant or revoke the execute privilege of stored procedures. You have the execute privilege on all stored procedures in database if you are a DBA.


Related topic:

Working with Stored Procedures
Changing Security Level