CODEWITHSUNDEEP
sql-serversql-server-2005ssis
user82431
user82431

Reputation: 1721

What privileges are required to store an SSIS package in SQL Server 2005?

I want to create an SSIS package as a DB User.

Also I want to store it to SQL Server, not in file system. The DB User only has the db_owner privilege on a particular database.

What least privileges are required to save SSIS to SQL Server?

Already I have assigned the following: 

grant execute on dbo.sp_ssis_checkexists to test
grant execute on dbo.sp_ssis_putpackage to test

Please provide feedback, thanks.

Upvotes: 4

Views: 5279

Answers (2)

Mohsin
Mohsin

Reputation:

Please add the user to following roles in msdb database:

  • db_dtsadmin
  • db_dtsltduser
  • db_dtsoperator

Hope it works.

More information on the Integration Services Roles in SQL Server 2005 can be found here: http://msdn.microsoft.com/en-us/library/ms141053%28v=sql.90%29.aspx.

Upvotes: 6

cfrag
cfrag

Reputation: 746

In case someone gets to this question misled by the title (it says Sql Server 2008 while the tags mention sql-server-2005), the privileges for the msdb database in SQL Server 2008 are:

db_ssisadmin
db_ssisltduser
db_ssisoperator

Upvotes: 3

Related Questions