The select permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
I have already tried to grant sqlagentoperatorrole and it didn't work. How do I resolve this error?
Sql-server – select permission was denied on the object ‘sysjobs’
permissionssql-server-2008
Related Question
- Sql-server – “The SELECT permission was denied” only for some of the tables
- Sql-server – The UPDATE permission was denied on the object
- Sql-server – What permissions does the service account need to use database mail
- Sql-server – The INSERT/UPDATE/DELETE permission was denied on the object ‘TheTable’, database ‘TheDb’, schema ‘dbo’
- Sql-server – Permissions not allowing Update or Select on a trigger executed function
- Sql-server – The EXECUTE permission was denied on the object ‘SPROC’, database ‘DATABASE’, schema ‘dbo’
Best Answer
You use the "SQL Server Agent Fixed Database Roles" in msdb (MSDN link).
And a "how to" for SSMS: "How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)"
Note: you need a user (MSDN) in one of these roles: no need to GRANT rights to sqlagentoperator