SQL Server 2014, Part 6 of 9: Permissions and Data Protection

In the SQL Server 2014: Permissions and Data Protection course you will understand permissions in SQL Server and how they provide granular control over data and objects. Then you will learn how to provide a final layer of defense by encrypting data.

Lesson 1:

• Permissions
• Permission Types
• Permission Statements
• Granting Permissions
• Demo: Assigning Permissions
• Roles, Permissions and Schemas
• Demo: Granting Permissions.

Lesson 2:

• Default Schemas for Users
• Demo: How Schemas Work
• Default Schemas for Groups
• Demo: Potential Problems.

Lesson 3:

• Execution Context
• Ownership Chaining
• Changing the Execution Content
• Demo: Execution content
• Metadata Security
• Demo: Permissions and Metadata.

Lesson 4:

• Data Encryption
• Encryption Keys
• Demo: How Encryption Works
• Key Management.

Lesson 5:

• Demo: Table Creation
• Demo: Certificate Keys
• Demo: Asymmetric Keys
• Demo: Symmetric Keys.