July 16, 2019 at 8:22 pm
Hey gurus,
I'm novice to SQL Server and in need of your help! I need to create a SQL Login for use by few people to run jobs created by 'xyz' account. Is there an easy way to do this? I don't want to add them to the SQL Agent roles in MSDB as I only want them to view and execute jobs created by user 'xyz'. Can you guys help with with the script or guid me how I can go about this business? Thank you as always!
Pehle
July 17, 2019 at 7:30 am
Hi I have a similar configuration on our SQL. I have used what I have tried to describe below. Hope it helps.
Create a credential and make sure that the identifier for the credential is a user that have the rights for the share you wish to store the backup on (if using a share)
You must to add a proxy and allow the logins that are supposed to run the backup on the Principals page for the Proxy (I'm using SSMS)
The backup jobs owner must be changed to the users supposed to use it and must run as the proxy created above.
This one I'm not sure of so it might not be needed
User must be granted exec on the following:
use msdb
grant exec on sp_get_composite_job_info to <user>
July 17, 2019 at 10:02 pm
A few things that might help:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply