Post reply

permission

  • February 7, 2008 at 12:50 pm

    #378424

    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 8, 2008 at 3:51 am

    #776335

    I guess it depends on what the SP is doing?

    select, update or delete?

    you need to view the tables permissions, and for the Apple user allow them to select, update or delete..

    Dave

  • February 8, 2008 at 7:29 am

    #776422

    user just want to just see the list of current jobs running, right now all he see is blank, but when he go with user=sa, he sees all jobs listing

  • February 8, 2008 at 1:16 pm

    #776580

    make him the member of targetserversrole in msdb database. Check more for targetserversrole in BOL.

    SQL DBA.

  • February 8, 2008 at 1:41 pm

    #776597

    Sanjay,

    when I made him the member of targetserverrole, it started giving some error, though it does not list what error it is....before that it was listing blank result

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

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