October 23, 2012 at 8:45 am
Is there way to give permissions user to run or schedule sql jobs.
October 23, 2012 at 8:57 am
Yes, all the permissions you need are on the MSDB database.
I think you need to assign them to the SQLAgentOperatorRole and db_ssisoperator role, but you will need to check if that is a sufficent level of privlages for them.
but ight have to crank up the user to be a member of the db_ssisltduser role as well.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
October 23, 2012 at 10:01 am
I don't see this permissions/roll on msdb
October 23, 2012 at 11:49 am
Goto the users property and check under the database membership
msdb | Security | Users | [UserName]
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply