Script to grant exec permission to all sps in a db

Question

Post reply

Script to grant exec permission to all sps in a db

harsha.majety

SSCommitted

Points: 1537
More actions
December 11, 2010 at 1:08 pm

#229571

Comments posted to this topic are about the item Script to grant exec permission to all sps in a db

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

J.O. Right there with Babe Points: 756 More actions · Answer 1

I usually create a role and grant execute permissions to that role then assign a user to that role.

MehmetGuzel Old Hand Points: 348 More actions · Answer 2

Short Way for SQL Server 2008 and SQL Server 2008 R2:

declare @strSQL varchar(max)

set @strSQL ='';

select @strSQL = @strSQL + ' grant exec on ' + name + ' to User1 ;' from sys.procedures

exec (@strSQL)

MS SQL Server DBA
www.mehmetguzel.net

sa_11 Newbie Points: 7 More actions · Answer 3

J.O. (12/13/2010)
I usually create a role and grant execute permissions to that role then assign a user to that role.

+1

simon.murin SSC-Addicted Points: 449 More actions · Answer 4

simon.murin

SSC-Addicted

Points: 449

December 13, 2010 at 3:40 pm

#1261968

GRANT EXECUTE ON SCHEMA::dbo TO USER1

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

sa_11 (12/13/2010)
J.O. (12/13/2010)
I usually create a role and grant execute permissions to that role then assign a user to that role.
+1

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events