Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script to grant exec permission to all sps in a db Expand / Collapse
Author
Message
Posted Saturday, December 11, 2010 1:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 16, 2014 2:48 PM
Points: 9, Visits: 435
Comments posted to this topic are about the item Script to grant exec permission to all sps in a db
Post #1033370
Posted Monday, December 13, 2010 9:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 7:54 AM
Points: 38, Visits: 309
I usually create a role and grant execute permissions to that role then assign a user to that role.
Post #1033871
Posted Monday, December 13, 2010 2:09 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 7:33 AM
Points: 114, Visits: 282
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
Post #1034077
Posted Monday, December 13, 2010 3:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 30, 2012 12:50 AM
Points: 1, Visits: 51
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
Post #1034110
Posted Monday, December 13, 2010 3:40 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 12:44 AM
Points: 77, Visits: 568
GRANT EXECUTE ON SCHEMA::dbo TO USER1
Post #1034113
Posted Monday, December 13, 2010 3:47 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1034117
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse