USE msdb; GO EXECUTE sp_addrolemember @rolename = 'role', @membername = 'username' GO
Where role is -
SQLAgentReaderRole - allows users to see all jobs
SQLAgentUserRole - allows users to create jobs and to manage the jobs that they create.
SQLAgentOperatorRole - allows users all of the rights assigned to the SQLAgentReaderRole along with the permissions necessary to execute local jobs that they do not own.
No comments:
Post a Comment