Diagrams

Table

Tenant Permission

DynamicsDocs.comTenant Permission«Table 2000000166»Tenant PermissionApp ID [PK]Role ID [PK]Role NameObject Type; [Table Data,Table,,Report...Object ID [PK]Object NameRead Permission; [,Yes,Indirect]Insert Permission; [,Yes,Indirect]Modify Permission; [,Yes,Indirect]Delete Permission; [,Yes,Indirect]Execute Permission; [,Yes,Indirect]Security Filter«Table 2000000165»Tenant Permission SetApp ID [PK]Role ID [PK]Name<Role ID>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 App ID (App ID) GUID
2 Role ID (Role ID) Code20
3 Role Name (Role Name) Text30 FlowField
4 Object Type (Object Type) Option
5 Object ID (Object ID) Integer
6 Object Name (Object Name) Text249 FlowField
7 Read Permission (Read Permission) Option
8 Insert Permission (Insert Permission) Option
9 Modify Permission (Modify Permission) Option
10 Delete Permission (Delete Permission) Option
11 Execute Permission (Execute Permission) Option
12 Security Filter (Security Filter) TableFilter

Keys

# Fields
0 App ID,Role ID,Object Type,Object ID (App ID,Role ID,Object Type,Object ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Object ID (Object ID) AllObjWithCaption Object ID (Object ID) 1..n
Role ID (Role ID) Tenant Permission Set Role ID (Role ID) 1..n

Table Relations From Other Tables

From Table From Field