December 11, 2010 at 1:08 pm
Comments posted to this topic are about the item Script to grant exec permission to all sps in a db
December 13, 2010 at 9:00 am
I usually create a role and grant execute permissions to that role then assign a user to that role.
December 13, 2010 at 2:09 pm
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
December 13, 2010 at 3:33 pm
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
December 13, 2010 at 3:40 pm
GRANT EXECUTE ON SCHEMA::dbo TO USER1
December 13, 2010 at 3:47 pm
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
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy