permission SELECT denied on ''SYSJOBS''

  • Hi,

    In the event Viewer I have an error which is :

    Source WebComponentsServices

    Method:CProbe

    Purge Error

    Permission SELECT denied on 'sysjobs', database 'msdb', owner 'dbo'

    What does it means ???

    Regards

  • The user connecting to view the system table sysjobs in msdb database does not have sufficient level of permissions to view it, as I would probably expect.

    Either grant explicit permissions, elevate the user  or disable the query

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • The only thing I can find on CProbe is a network probing utility. Are you running any specialized network monitoring tools. Might be an attack of some kind but you need to correlate if it has any specific variables such as a specific IP address that causes the error.

    Also, do you use MS MOM?

Viewing 3 posts - 1 through 2 (of 2 total)

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