Error: the select permission was denied on the object 'sysjobschedules' database 'msdb' schema 'dbo'

Question

Error: the select permission was denied on the object 'sysjobschedules' database 'msdb' schema 'dbo'

varunthakur84

SSC Veteran

Points: 288
More actions
May 28, 2013 at 2:45 am

#294521

Error: the select permission was denied on the object 'sysjobschedules' database 'msdb' schema 'dbo'
Hi All
Please help me to fix this issue ASAP. Its very important for me.
I would appreciate if someone can also provide me SQL scripts to see/fix the issues if possible.
Thanks & Regards
Varun

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

rharderwijk Ten Centuries Points: 1119 More actions · Answer 1

Varun,

Could you please provide a little context on what you are trying to achieve? With this short description, I can only say that you lack permissions to perform the query...

Cheers

Rick

varunthakur84 SSC Veteran Points: 288 More actions · Answer 2

Hi Rick

In my product we have implemented archiving process by using SQL jobs.

We are just storing Time in a table from where SQL jobs reading time to further execute archiving related stored

procedures.

Thanks & Regards

Varun

rharderwijk Ten Centuries Points: 1119 More actions · Answer 3

Varun,

Have you checked if the account that your job is running as, has permissions on the database?

Cheers,

Rick

J Good Default port Points: 1435 More actions · Answer 4

You can grant select access to only the sysjobschedules table like this:

--Create user on msdb for a server login 'testUSER'

--This is assuming you already have the testUSER login created on the server

USE [msdb]

GO

CREATE USER [testUSER] FOR LOGIN [testUSER]

GO

--Grant USER select access on sysjobschedules

use [msdb]

GO

GRANT SELECT ON [dbo].[sysjobschedules] TO [testUSER]

GO

Twitter: @SQL_JGood
Blog: sqljgood.wordpress.com/[/url]