1

I would like to have one script to remove the specific user group to execute all stored procedures on the specific database in SQL Server 2014. I searched the web and found the example at Grant Revoke Permissions On Stored Procedures in SQL Server. It looks like I need create the script for all stored procedure.

Also I found another website REVOKE Object Permissions (Transact-SQL). However I have no clue how to write it as one script for all stored procedure.

Also I tried to use the below script in the database, but the Sales group still has permission on the stored procedure.

revoke execute to [Sales]

Would anyone tell me what should I do?

Jonathan Leffler
  • 730,956
  • 141
  • 904
  • 1,278
user819774
  • 1,456
  • 1
  • 19
  • 48

0 Answers0