Partilhar via

Granting Full Control Permissions

  • Artigo

A member of the server role for an instance of Microsoft SQL Server 2005 Analysis Services (SSAS) 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

  1. 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).

  2. Click General in the Select a Page pane, and then select the Full Control (Administrator) check box for the cube.

See Also

Tasks

Granting Process Permissions

Concepts

Granting Read Metadata Permissions
Roles (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance