.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SQLAgentUserRole

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Hello,

I would like to grant a user permission to execute a SQL job. I there a way to do this. I know that SQLAgentUserRole grants execute permissions, but I believe that is for all jobs. I would like to restrict this user to one particular SQL job.

Any help would be appreciated.

 

CODE SNIPPET:

use MSDB;
EXECUTE sp_addrolemember

@rolename = 'SQLAgentUserRole',

@membername = 'GLOBAL\USERNAME'


Dave SQL Developer


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend