The following example revokes EXECUTE permission on the stored procedure HumanResources. UspUpdateEmployeeHireInfo from an application role called Recruiting11.

• 以下示例从名为Recruiting11的应用程序角色中撤消对存储过程HumanResources.；uspUpdateEmployeeHireInfo的EXECUTE权限。