June 28, 2002 at 4:49 am
Hello ,
I am new on sqlserver ( better said very new ) .
I have problems running jobs , i am looking for exact privileges that need a user to run jobs .
The configuration is as follow :
- owner of dts package is domain/userapps
- autentification of sql server agent by operating system.
- user usrapps is dbo of every database . ( i would like to avoid this ).
My question is : what are the privileges does a user need to have in order to run jobs correctly ... and in which databases??
thanks in advance for your help
arnaud
July 3, 2002 at 1:46 am
quote:
Hello ,I am new on sqlserver ( better said very new ) .
I have problems running jobs , i am looking for exact privileges that need a user to run jobs .
The configuration is as follow :
- owner of dts package is domain/userapps
- autentification of sql server agent by operating system.
- user usrapps is dbo of every database . ( i would like to avoid this ).
My question is : what are the privileges does a user need to have in order to run jobs correctly ... and in which databases??
thanks in advance for your help
arnaud
July 3, 2002 at 2:01 am
Hi Arnaud
Don't know how your skills are seeing that you are new to SQL.
Create application roles for your applications. Avoid making apps the dbo of databases to prevent broken ownership at a later stage.
Create a domain account with which you can startup your services etc. and assign permissions. Use the local systems account if permits.
Read up on BOL its all there.
Cheers
peter
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply