• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 46
  • Last Modified:

SQL Stored Procedure

I have a stored procedure that I want to grant execute permission for all users.  This is being use in an excel file with powerpivot and I don't want to have to add each individual.  

Is there anyway to be able to add all users?
0
holemania
Asked:
holemania
1 Solution
 
Salah Eddine ELMRABETTechnical Lead Manager (Owner)Commented:
Hi,

Create a role add this role to users, and then you can grant execute to all the routines in one shot to this role:

CREATE ROLE <abc>
GRANT EXECUTE TO <abc>

For more details, see GRANT Schema Permissions (Transact-SQL)

Best regards.

Salah
0
 
John_VidmarCommented:
grant all on proc_name to public
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What that SP does?
The users are domain users or each one has a respective SQL Server user in the database?
0
 
holemaniaAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now