Chapter 18. Securing Packages

IN THIS CHAPTER

• Controlling Package Access

• Identifying Sensitive Data

• Protecting Packages and Other Files

• Integrating with SQL Server Agent

• Detecting Package Modification

• Security Scenario Settings

“EXCUSE ME. I’M IN CHARGE OF SECURITY HERE, MILADY.”—ANAKIN SKYWALKER

With all the hackers out there, it’s easy to narrowly think of Integration Services security as a set of features that protect against malicious attacks. Although that’s certainly part of the security equation, protecting packages is a much broader and more complex problem. You need to prevent the wrong people from changing or executing the package while still allowing the right people that access. You need to provide for access combinations ...

Get Microsoft SQL Server 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial