Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/StackDBAs/status/893707292394364929
added 39 characters in body; edited title
Source Link
marc_s
marc_s
  • 9.1k
  • 6
  • 46
  • 52

MSSQL SQL Server : which role grants permission to execute all stored procedures?

Which database role membership grants permission to execute all existing stored procedures in MSSQLSQL Server 2012?

I tried adding a user to each of them and am still unable to execute an spa stored procedure. I don't wanna grant EXECUTEwant to grant EXECUTE for each spstored procedure separately, I wannawant to add the user to a role and he be able to execute any of them.

MSSQL: which role grants permission to execute all stored procedures?

Which database role membership grants permission to execute all existing stored procedures in MSSQL 2012?

I tried adding a user to each of them and am still unable to execute an sp. I don't wanna grant EXECUTE to each sp separately, I wanna add the user to a role and he be able to execute any of them.

SQL Server : which role grants permission to execute all stored procedures?

Which database role membership grants permission to execute all existing stored procedures in SQL Server 2012?

I tried adding a user to each of them and am still unable to execute a stored procedure. I don't want to grant EXECUTE for each stored procedure separately, I want to add the user to a role and he be able to execute any of them.

Source Link
Hikari
Hikari
  • 1.6k
  • 12
  • 28
  • 42

MSSQL: which role grants permission to execute all stored procedures?

Which database role membership grants permission to execute all existing stored procedures in MSSQL 2012?

I tried adding a user to each of them and am still unable to execute an sp. I don't wanna grant EXECUTE to each sp separately, I wanna add the user to a role and he be able to execute any of them.