Post reply

sql_help_job help!! urgent

  • February 7, 2008 at 12:49 pm

    #122011

    Currently, user apple can exec sp_help_job (system stored procedure) in database msdb on Server/Instance name CALFI303 but it doesn't return any records. What permissions I need to give to the User apple ? If I sign on with sa, it returns the records with no problem.

  • February 20, 2008 at 9:06 pm

    #780490

    How about to grant EXEC to your user for executing this stored procedure?

  • February 28, 2008 at 5:34 pm

    #783542

    Grant execute permission to the SP on msdb.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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