Grant Full Control Permissions on an Analysis Services Multidimensional Database
A member of the server role for an instance of Microsoft SQL Server Analysis Services can create a database role with Full Control (Administrator) permissions within a particular database, and then add Microsoft Windows users and groups to that database role. As a member of a database role that has Full Control (Administrator) permissions, a Windows user can perform any task within the database, including:
Processing database objects.
Reading database data.
Reading database metadata.
Adding users to existing database roles.
Creating new database roles.
Defining permissions for database roles.
Procedure
To give a database role Full Control (Administrator) permissions
In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object Explorer, and then click a database role (or create a new database role).
Click General in the Select a Page pane, and then select the Full Control (Administrator) check box for the cube.
Ayrıca bkz.
Görevler
Grant Process Permissions on an Analysis Services Multidimensional Database
Kavramlar
Grant Read Metadata Permissions on an Analysis Services Multidimensional Database