holemania
asked on
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?
Is there anyway to be able to add all users?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
grant all on proc_name to public
What that SP does?
The users are domain users or each one has a respective SQL Server user in the database?
The users are domain users or each one has a respective SQL Server user in the database?
ASKER
Thanks.