Data roles table

Name	Definition
ModelName	nvarchar(50) NOT NULL; PK
Name	nvarchar(50) NOT NULL; PK
Description	nvarchar(150) NULL
Permissions	int NULL

This table shows permission values in the DEPM_MOD_DATAROLE table:

Value	Global OLAP permission
0	None
1	View OLAP
2	View OLAP and Write Values
3	Write Values
4	Import/Export Values
5	Import/Export Values, View OLAP only
6	Import/Export Values, View OLAP and Write Values
7	Import/Export Values, Write Values
8	Edit Rules
9	Edit Rules, View OLAP only
10	Edit Rules, View OLAP and Write Values
11	Edit Rules, Write Values
12	Edit Rules, Import/Export Values
13	Edit Rules, Import/Export Values, View OLAP only
14	Edit Rules, Import/Export Values, View OLAP and Write Values
15	Edit Rules, Import/Export Values, Write Values
16	Edit Dimensions
17	Edit Dimensions, View OLAP only
18	Edit Dimensions, View OLAP and Write Values
19	Edit Dimensions, Write Values only
20	Edit Dimensions, Import/Export Values
21	Edit Dimensions, Import/Export Values, View OLAP
22	Edit Dimensions, Import/Export Values, View OLAP and Write Values
23	Edit Dimensions, Import/Export Values, Write Values
24	Edit Dimensions, Edit Rules
25	Edit Dimensions, Edit Rules, View OLAP
26	Edit Dimensions, Edit Rules, View OLAP and Write Values
27	Edit Dimensions, Edit Rules, Write Values
28	Edit Dimensions, Edit Rules, Import/Export Values
29	Edit Dimensions, Edit Rules, Import/Export Values, View OLAP
30	Edit Dimensions, Edit Rules, Import/Export Values, View OLAP and Write Values
31	Edit Dimensions, Edit Rules, Import/Export Values, Write Values
32	Administer OLAP database
33	Administer OLAP database, View OLAP
34	Administer OLAP database, View OLAP and Write Values
35	Administer OLAP database, Write Values
36	Administer OLAP database, Import/Export Values
37	Administer OLAP database, Import/Export Values, View OLAP
38	Administer OLAP database, Import/Export Values, View OLAP and Write Values
39	Administer OLAP database, Import/Export Values, Write Values
40	Administer OLAP database, Edit Rules
41	Administer OLAP database, Edit Rules, View OLAP
42	Administer OLAP database, Edit Rules, View OLAP and Write Values
43	Administer OLAP database, Edit Rules, Write Values
44	Administer OLAP database, Edit Rules, Import/Export Values
45	Administer OLAP database, Edit Rules, Import/Export Values, View OLAP
46	Administer OLAP database, Edit Rules, Import/Export Values, View OLAP and Write Values
47	Administer OLAP database, Edit Rules, Import/Export Values, Write Values
48	Administer OLAP database, Edit Dimensions
49	Administer OLAP database, Edit Dimensions, View OLAP
50	Administer OLAP database, Edit Dimensions, View OLAP and Write Values
51	Administer OLAP database, Edit Dimensions, Write Values
52	Administer OLAP database, Edit Dimensions, Import/Export Values
53	Administer OLAP database, Edit Dimensions, Import/Export Values, View OLAP
54	Administer OLAP database, Edit Dimensions, Import/Export Values, View OLAP and Write Values
55	Administer OLAP database, Edit Dimensions, Import/Export Values, Write Values
56	Administer OLAP database, Edit Dimensions, Edit Rules
57	Administer OLAP database, Edit Dimensions, Edit Rules, View OLAP
58	Administer OLAP database, Edit Dimensions, Edit Rules, View OLAP and Write Values
59	Administer OLAP database, Edit Dimensions, Edit Rules, Write Values
60	Administer OLAP database, Edit Dimensions, Edit Rules, Import/Export Values
61	Administer OLAP database, Edit Dimensions, Edit Rules, Import/Export Values, View OLAP
62	Administer OLAP database, Edit Dimensions, Edit Rules, Import/Export Values, View OLAP and Write Values
63	Administer OLAP database, Edit Dimensions, Edit Rules, Import/Export Values, Write Values

The DEPM_MOD_DATAROLE table has these references:

Source columns	Target table	Target columns
ModelName	_model	Name