|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Who is the owner of dynamic job created in my sql server from my ASP.NET app?From my ASP.NET app (which is impersonating under a domain account) ,I am
trying to call an stored procedure which creates a temporary job and then delete it. Dose any one know what type of permission do I need to execute the stored proc from within my ASP.NET app? Sorry I meant ,what type of permission my impersonated user needs to have to
create the temporary job through the stored procedure? Thanks a lot Show quote "J-T" <J-T@nospam.com> wrote in message news:erwjMbRpFHA.3940@TK2MSFTNGP14.phx.gbl... > From my ASP.NET app (which is impersonating under a domain account) ,I am > trying to call an stored procedure which creates a temporary job and then > delete it. Dose any one know what type of permission do I need to execute > the stored proc from within my ASP.NET app? > I believe that your user will need execute rights on the job stored
procedures in msdb. Probably will also need datawriter as well. Others may know better, but since no one had posted to this in a while, I thought I would at least hazard a guess. Stu I so appreciate your help.I am still waiting for other answers too to make a
comclusion. Thanks a lot Show quote "Stu" <stuart.ainswo***@gmail.com> wrote in message news:1124508179.546184.100290@o13g2000cwo.googlegroups.com... >I believe that your user will need execute rights on the job stored > procedures in msdb. Probably will also need datawriter as well. > > Others may know better, but since no one had posted to this in a while, > I thought I would at least hazard a guess. > > Stu > Can you eloborate it. I Mean what kind of operations the user is expected to
do in the back end. Is he creating temp sprocs then he must have ddl permissions too. Regards R.D Show quote "J-T" wrote: > I so appreciate your help.I am still waiting for other answers too to make a > comclusion. > > Thanks a lot > "Stu" <stuart.ainswo***@gmail.com> wrote in message > news:1124508179.546184.100290@o13g2000cwo.googlegroups.com... > >I believe that your user will need execute rights on the job stored > > procedures in msdb. Probably will also need datawriter as well. > > > > Others may know better, but since no one had posted to this in a while, > > I thought I would at least hazard a guess. > > > > Stu > > > > > You don't need any permission by default. Execute permissions on the job procedures are given to
public in msdb and there is a guest in msdb. I recommend removing guest from msdb and only add the logins as users to msdb that need to create jobs. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Stu" <stuart.ainswo***@gmail.com> wrote in message news:1124508179.546184.100290@o13g2000cwo.googlegroups.com... >I believe that your user will need execute rights on the job stored > procedures in msdb. Probably will also need datawriter as well. > > Others may know better, but since no one had posted to this in a while, > I thought I would at least hazard a guess. > > Stu >  |
|||||||||||||||||||||||
Other interesting topics