O'Reilly logo

Microsoft SQL Server 2005 Integration Services by Kirk Haselden

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required