Post reply

permission SELECT denied on ''SYSJOBS''

  • March 16, 2005 at 2:20 am

    #362238

    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

  • March 16, 2005 at 7:19 am

    #547255

    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/

  • March 16, 2005 at 7:20 am

    #547256

    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