We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

2005 & 2008 SSIS Packages

Medium Priority
544 Views
Last Modified: 2013-11-30
I know in 2000 I cannot setup a user to only be able to execute and modify only certain DTS packages.  It is either all of them or none of them.  With SQL Server 2005 or 2008 in SSIS is it possible to do this?
Comment
Watch Question

Commented:
I dont know about user based permissions. But you can set passwords on the packages and share it with only the users that should get access on them
Nathan RileyFounder

Author

Commented:
Well what do you mean users that get access on them?  So I can say that user test can only access these SSIS packages but not others?
I don't think there any option grant the access to perticular SSIS package(s) to one or more logins but you can create a procedure with the option EXECUTE AS  using xp_cmdshell and dtexec to execute ssis package and GRANT the execute permissions to the user.

SQL SERVER EXPERT
CERTIFIED EXPERT
Commented:

Integration Services includes the three fixed database-level roles db_dtsadmin, db_dtsltduser, and db_dtsoperator for controlling access to packages
http://msdn.microsoft.com/en-us/library/ms141053(SQL.90).aspx 
more:
Security Considerations for Integration Services
http://msdn.microsoft.com/en-us/library/ms137833(SQL.90).aspx
----------------------------------------------
execution you may try to control via sqlagent jobs for SSIS pack
----
access you may try to control by placing SSIS pack in folders witj NTFS permissions for specific users

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.