hi

what's best practice (security wise) in granting a user access right to edit say the description of a job.

thankss

To add a SQL login or msdb role to a SQL Server Agent fixed database role

1. In Object Explorer, expand a server.

2. Expand Security, and then expand Logins.

3. Right-click the login you wish to add to a SQL Server Agent fixed database role, and select Properties.

4. On the User Mapping page of the Login Properties dialog box, select the row containing msdb.

5. Under Database role membership for: msdb, check the appropriate SQL Server Agent fixed database rol

Refer https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c62b61a0-7f66-4cb9-a5a6-577d5f73e8aa/permissions-to-modify-sql-agent-jobs?forum=sqlsecurity#03aa1492-8e9b-49b9-bc84-e44b5e0798f1

:https://msdn.microsoft.com/en-us/library/ms187901.aspx

http://www.sqlservercentral.com/Forums/Topic1029390-1550-1.aspx

Thanks

Abhishek

• Edited by Abhishek0127[Abhishek kumar]MVP Thursday, August 27, 2015 3:02 PM
• Proposed as answer by Lydia ZhangMicrosoft contingent staff, Moderator Friday, August 28, 2015 7:55 AM
• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator 23 hours 6 minutes ago

hi

thanks for your time to reply - is there any T-SQL Scripting for this?

thanks