SSIS 2014, Part 11 of 11: Security

In this course, you’ll start by learning about the typical threats that the security tools in Integration Services help protect against. Then you’ll learn how to control access to packages stored in the Package Store in SQL Server, about the available roles and how to create a custom role, as well as how to sign a package with a digital certificate. Then you’ll learn about the new security features that come with the SSIS Catalog introduced in SQL Server 2012, which more closely emulates the security scheme in the SQL Server database engine.

Lesson 1:

• Integration Services Security
• Protecting Sensitive Info
• Sensitive Information
• Protection Level
• ProtectionLevel Property Values.

Lesson 2:

• Demo: Package Protection Level
• Demo: EncryptAllWithPassword
• Demo: Examining the Code.

Lesson 3:

• Integration Services Roles
• Authorize IS Users in SQL Server
• Demo: Authorize Users in SQL
• Demo: Testing Authorization.

Lesson 4:

• Demo: Creating a Custom Role
• Signing with Digital Certificates.

Lesson 5:

• Securable Objects
• Permissions
• Managing Security
• Demo: Manage Permissions.