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.

Articles Related

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.