C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

GRANT permission to ALL stored procedures

Posted Date: 02 May 2007 Resource Type: Code Snippets Category: SQL

Posted By: Vadivel Mohanakrishnan Member Level: Diamond
Rating:

Points: 10

I have created a fresh login in my SQL Server 2005 database. Now I want to grant that newly created login a/c permissions to execute any / all stored procedure within that database. Wondering how to do this? Read on.


Declare @strUserName sysname

Set @strUserName = 'Support'

Select 'Grant exec on [' + Routine_Schema + '].[' + Routine_Name + '] TO [' + @strUserName + ']' from Information_Schema.Routines Where Routine_Type = 'Procedure'

Now in the result pane the GRANT statement for all stored procedure would have been created something like this:



Grant exec on [dbo].[SampleSp_UsingDynamicQueries] TO [Support]

Just copy the whole result pane and execute it at one shot.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Find the missing numbers (GAPS) within a table...
	Previous Resource: How to find out recently run queries in SQL Server 2005?
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

it support