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 DEPM_MOD_DATAROLE table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| ModelName | _model | Name |