We help IT Professionals succeed at work.

SQL Stored Procedure

holemania
holemania asked
on
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?
Comment
Watch Question

Technical 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
grant all on proc_name to public
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
What that SP does?
The users are domain users or each one has a respective SQL Server user in the database?

Author

Commented:
Thanks.