Granting Administrative Permissions Within a Database

In Microsoft SQL Server, members of the server role for SQL Server Analysis Services can create one or more database roles within a database, and then grant full or limited administrative permissions within the database to these database roles. Members of the Analysis Services server role can then add Microsoft Windows users and groups to these database roles.

The following topics discuss the various permissions that the Analysis Services server role can grant to a database role.

If the database role has	See
Full administrative permissions within the database	Granting Full Control Permissions
Only permission to process certain Analysis Services objects	Granting Process Permissions
Permission to view the object definition for an Analysis Services object, but not process the object or view the actual data	Granting Read Metadata Permissions

See Also

Tasks

Granting Server-Wide Administrative Permissions

Concepts

Granting User Access

Security Roles (Analysis Services - Multidimensional Data)