Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Granting Administrative Permissions Within a Database

In Microsoft SQL Server 2005, members of the server role for SQL Server 2005 Analysis Services (SSAS) 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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.