SQL Server Performance

application splitting / user rights

Discussion in 'SQL Server 2008 Integration Services' started by acki4711, Oct 27, 2010.

  1. acki4711 Member

    Hi all,
    We have a central db setup with more applications sharing one instance.
    Each application has its one db(s) and AD groups allowing access only to the db for the defined application.
    -> works like a charm
    Is it possible to acieve the same for ssis packages as well?
    A specific user should only be allowed to see/execute/update etc. it's own set of packages?
    How to?
    TIA for some light.
    acki4711
  2. MohammedU New Member

    If you are planning to save the SSIS packages in MSDB, I don't think it is possible to seperate the permissions.
    Where as you can save them into a folder and share the folder accordingly to appropriate users.
  3. Esspweb New Member

    I am completely agree with you MohammedU. He is absolutely right.
  4. FrankKalis Moderator

    [quote user="Esspweb"]
    I am completely agree with you MohammedU. He is absolutely right.
    [/quote]
    I hope your reply is not just a cheap way of promoting your site...

Share This Page