OLAP data roles

Data roles are essential for managing access permissions to cubes, elements, and cells within the OLAP database. Any OLAP Modeling user can manage data roles and their global OLAP permissions.

Data roles are published one-way from the DEPM_MOD_DATAROLE table to the repository database. If a data role already exists in the repository database, that role is overwritten by a role from the DEPM_MOD_DATAROLE table.

Ensure that all data roles are included in the DEPM_MOD_DATAROLE object definition table before you publish the model.

When a data role is deleted, it is removed from the DEPM_MOD_DATAROLE table. To ensure data integrity, all associated permissions and references in other related tables are also removed.

Any updates to data roles, such as adding, editing, and deleting a data role, become effective in the OLAP database after you publish the model or the dimension with access control.

Caution:

Data role deletion can affect all access cubes that use the role, which can affect user access and permissions across the system.