Share via


Role Designer (SSAS)

Use Role Designer in Business Intelligence Development Studio and SQL Server Management Studio to define or modify a role. You can display the Role Designer dialog box in Business Intelligence Development Studio by:

  • Right-clicking the Roles folder in an Analysis Services project in Solution Explorer and selecting New Role.
  • Double-clicking a role in Solution Explorer or right-clicking a role in Solution Explorer and selecting Open or View Designer.

You can display Role Designer in SQL Server Management Studio by right-clicking the Roles folder or a role in an Analysis Services database in Object Explorer and selecting New Role.

Role Designer contains the pages listed in the following table.

Pages

Page Definition

General

Use this page to set the name, description, and database permissions for the role. For more information about this page, see General (Role Designer) (SSAS).

Membership

Use this page to specify the Microsoft Windows users and groups included in the role. For more information about this page, see Membership (Role Designer) (SSAS).

Data Sources

Use this page to specify data source permissions for the role. For more information about this page, see Data Sources (Role Designer) (SSAS).

Cubes

Use this page to specify cube permissions for the role. For more information about this page, see Cubes (Role Designer) (SSAS).

Cell Data

Use this page to specify cell permissions for the role. For more information about this page, see Cell Data (Role Designer) (SSAS).

Dimensions

Use this page to specify dimension permissions for the role. For more information about this page, see Dimensions (Role Designer) (SSAS).

Dimension Data

Use this page to specify dimension attribute and member permissions for the role. For more information about this page, see Dimension Data (Role Designer) (SSAS).

Mining Structures

Use this page to specify mining structure and mining model permissions for the role. For more information about this page, see Mining Structures (Role Designer) (SSAS).

See Also

Reference

Analysis Services Designers and Dialog Boxes (SSAS)

Other Resources

Roles (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance