Data roles table

The DEPM_MOD_DATAROLE table specifies OLAP permissions.
Name Definition
ModelName nvarchar(50) NOT NULL; PK
Name nvarchar(50) NOT NULL; PK
Description nvarchar(150) NULL
Permissions int NULL

These flags represent OLAP permissions.

  • 0 or NULL: No permission
  • 1: View OLAP
  • 2: View OLAP and write values

The table has these references:

Source columns Target table Target columns
ModelName _model Name