Lesson 10: Defining Administrative Roles

In this lesson, you learn to define security roles for administrative tasks.


A completed project through Lesson 9 is available by downloading and installing the samples. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

This lesson contains the following task:

Granting Process Database Permissions

In this task, you define a security role that has permissions to process the Analysis Services database, and then you test this security role. For more information, see Granting Administrative Permissions Within a Database.