SSAS - Database Role

> Database > SQL Server - SQL Server Analysis Services (OLAP)

1 - About

A database role permits to assign permissions:

  • to users,
  • or to administrators who do not have server-wide administrative rights.

Role permissions are database-specific.

Advertising

3 - Securables

Database role permissions can be granted for:

  • database and cube dimensions,
  • individual dimension members,
  • cubes,
  • individual cells within a cube,
    • mining structures,
    • mining models,
    • data sources,
    • and stored procedures.

4 - Management

  • In SQL Server Management Studio, expand the database, and then right-click the Roles folder to add a new role.
  • In SQL Server Data Tools, roles are displayed in Solution Explorer and you can add them from the Project menu.