HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

select permission was denied on the object 'sysjobs'

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thepermissionsysjobsdeniedwasselectobject

Problem

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?

Solution

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

Context

StackExchange Database Administrators Q#3237, answer score: 5

Revisions (0)

No revisions yet.