SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Harsha Majety / Script to grant exec permission to all sps in a db / Latest Posts

RE: Script to grant exec permission to all sps in a db

SQLRNNR — Mon, 13 Dec 2010 15:47:36 GMT

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

RE: Script to grant exec permission to all sps in a db

simon.murin — Mon, 13 Dec 2010 15:40:50 GMT

GRANT EXECUTE ON SCHEMA::dbo TO USER1

RE: Script to grant exec permission to all sps in a db

sa_11 — Mon, 13 Dec 2010 15:33:47 GMT

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

RE: Script to grant exec permission to all sps in a db

mehmetguzel — Mon, 13 Dec 2010 14:09:27 GMT

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.proceduresexec (@strSQL)

RE: Script to grant exec permission to all sps in a db

J.O. — Mon, 13 Dec 2010 09:00:26 GMT

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

Script to grant exec permission to all sps in a db

harsha.majety — Sat, 11 Dec 2010 13:08:39 GMT

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