SSAS - Database Role

Card Puncher Data Processing

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.

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.

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.





Discover More
Ssas Cube Browser Impersonate
SSAS - Security

SSAS relies on Windows authentication to authenticate users. After a user has been authenticated, SSAS controls permissions within the databases based on the user’s role membership. Principals...
Card Puncher Data Processing
SSAS - Server Role

The server role is a fixed role at the server level. Its permissions cannot be changed and an other server role can not bed added. The server role gives the administrator access to SSAS. Members of...



Share this page:
Follow us:
Task Runner