February 22, 2008 at 1:00 pm
Hello,
Any suggestion on how to setup/grant access to a developer to create SSIS packages? He is db_owner in his own dev db.
Many thanks. Jeff
February 23, 2008 at 12:51 am
Jeff (2/22/2008)
Hello,Any suggestion on how to setup/grant access to a developer to create SSIS packages? He is db_owner in his own dev db.
Are these SSIS packages going to be run as SQL jobs through the SQL Agent in production?
If that's the case, the SQL Agent account will need to have sufficient permissions to access the database objects in question. I assume that account is sa on the instance?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 25, 2008 at 5:58 am
Hi,
initially, the pkg will need to created & run by the developer for testing ... then i suspect we will be automating the process (importing xml data nightly) via sql agent job. currently sql agent is configured under a domain account (with sysadmin role) ... i heard there was now a proxy account?
Many thanks. Jeff
February 25, 2008 at 11:26 am
Jeff (2/25/2008)
Hi,initially, the pkg will need to created & run by the developer for testing ... then i suspect we will be automating the process (importing xml data nightly) via sql agent job. currently sql agent is configured under a domain account (with sysadmin role) ... i heard there was now a proxy account?
Unfortunately, I am not familiar with proxy accounts, and I have always created and run packages as sysadmin.
However, as far as the bare-min privileges of the user creating the package are concerned, you will need:
...permissions sufficient to write to the msdb database or to the file system. In Integration Services, this requires INSERT permissions on the msdb database.
(see http://msdn2.microsoft.com/en-us/library/ms140052.aspx for info on other permissions).
See also:
Integration Services Roles, http://msdn2.microsoft.com/en-us/library/ms141053.aspx
You may want to try assigning your user to one of the roles mentioned (db_dtsltduser perhaps?) and see if that works for you.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 25, 2008 at 11:36 am
hi, excellent ! i think this is exactly what i'm looking for ... there are new db roles for DTS vs giving the developer the sysadmin server role.
many thanks again.
Many thanks. Jeff
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply