application splitting / user rights | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

application splitting / user rights

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.

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.

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

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


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |