February 7, 2008 at 12:50 pm
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
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
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
make him the member of targetserversrole in msdb database. Check more for targetserversrole in BOL.
SQL DBA.
February 8, 2008 at 1:41 pm
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