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.
@rolename = 'SQLAgentUserRole',
@membername = 'GLOBAL\USERNAME'
Dave SQL Developer
View Complete Post