title | description | ms.date | ms.service | ms.topic | ms.assetid | author | ms.author | search.audienceType | |
---|---|---|---|---|---|---|---|---|---|
Table Permission (mspp_entitypermission) table/entity reference (Microsoft Dataverse) | Microsoft Docs |
Includes schema information and supported messages for the Table Permission (mspp_entitypermission) table/entity. |
02/22/2024 |
powerapps |
reference |
3948cc48-07c8-7f60-0608-71c37158ad7c |
phecke |
pehecke |
|
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Added by: Power Pages Apps Solution
Message | Web API Operation | SDK class or method |
---|---|---|
BulkRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Create | POST /mspp_entitypermissions See Create |
xref:Microsoft.Xrm.Sdk.Messages.CreateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Create* |
CreateMultiple | <xref:Microsoft.Dynamics.CRM.CreateMultiple?displayProperty=nameWithType /> | xref:Microsoft.Xrm.Sdk.Messages.CreateMultipleRequest |
Delete | DELETE /mspp_entitypermissions(mspp_entitypermissionid) See Delete |
xref:Microsoft.Xrm.Sdk.Messages.DeleteRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Delete* |
PurgeRetainedContent | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Retain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Retrieve | GET /mspp_entitypermissions(mspp_entitypermissionid) See Retrieve |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Retrieve* |
RetrieveEntityChanges | xref:Microsoft.Xrm.Sdk.Messages.RetrieveEntityChangesRequest | |
RetrieveMultiple | GET /mspp_entitypermissions See Query Data |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple* |
RollbackRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Update | PATCH /mspp_entitypermissions(mspp_entitypermissionid) See Update |
xref:Microsoft.Xrm.Sdk.Messages.UpdateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Update* |
UpdateMultiple | <xref:Microsoft.Dynamics.CRM.UpdateMultiple?displayProperty=nameWithType /> | xref:Microsoft.Xrm.Sdk.Messages.UpdateMultipleRequest |
ValidateRetentionConfig | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. |
Property | Value |
---|---|
CollectionSchemaName | mspp_entitypermissions |
DisplayCollectionName | Table Permissions |
DisplayName | Table Permission |
EntitySetName | mspp_entitypermissions |
IsBPFEntity | False |
LogicalCollectionName | mspp_entitypermissions |
LogicalName | mspp_entitypermission |
OwnershipType | OrganizationOwned |
PrimaryIdAttribute | mspp_entitypermissionid |
PrimaryNameAttribute | mspp_entityname |
SchemaName | mspp_entitypermission |
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- mspp_accountrelationship
- mspp_append
- mspp_appendto
- mspp_contactrelationship
- mspp_create
- mspp_createdby
- mspp_createdon
- mspp_delete
- mspp_entitylogicalname
- mspp_entityname
- mspp_entitypermissionId
- mspp_modifiedby
- mspp_modifiedon
- mspp_parententitypermission
- mspp_parentrelationship
- mspp_read
- mspp_scope
- mspp_websiteid
- mspp_write
- statecode
- statuscode
Property | Value |
---|---|
Description | |
DisplayName | Account Relationship |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_accountrelationship |
MaxLength | 1000 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Controls whether the user can attach another record to the specified record. The Append and Append To permissions work in combination. |
DisplayName | Append |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_append |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | Controls whether the user can append the specified record to another record. The Append and Append To permissions work in combination. |
DisplayName | Append To |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_appendto |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | |
DisplayName | Contact Relationship |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_contactrelationship |
MaxLength | 1000 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | The Create privilege controls whether you can create a record. |
DisplayName | Create |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_create |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the record was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_createdon |
RequiredLevel | None |
Type | DateTime |
Property | Value |
---|---|
Description | Controls whether the user can delete a record. |
DisplayName | Delete |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_delete |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | |
DisplayName | Table Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_entitylogicalname |
MaxLength | 250 |
RequiredLevel | ApplicationRequired |
Type | String |
Property | Value |
---|---|
Description | The name of the custom entity. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_entityname |
MaxLength | 400 |
RequiredLevel | ApplicationRequired |
Type | String |
Property | Value |
---|---|
Description | Unique identifier for entity instances |
DisplayName | Table Permission |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | mspp_entitypermissionid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the record was modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_modifiedon |
RequiredLevel | None |
Type | DateTime |
Property | Value |
---|---|
Description | |
DisplayName | Parent Table Permission |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_parententitypermission |
RequiredLevel | None |
Targets | mspp_entitypermission |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | Parent Relationship |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_parentrelationship |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Controls whether the user can read a record. |
DisplayName | Read |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_read |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | |
DisplayName | Access Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_scope |
RequiredLevel | ApplicationRequired |
Type | Picklist |
Value | Label | Description |
---|---|---|
756150000 | Global | |
756150001 | Contact | |
756150002 | Account | |
756150003 | Parent | |
756150004 | Self |
Property | Value |
---|---|
Description | Unique identifier for Website associated with Entity Permission |
DisplayName | Website |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_websiteid |
RequiredLevel | ApplicationRequired |
Targets | mspp_website |
Type | Lookup |
Property | Value |
---|---|
Description | Controls whether the user can update a record. |
DisplayName | Write |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_write |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | Status of the Table Permission |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Inactive | 2 | Inactive |
Property | Value |
---|---|
Description | Reason for the status of the Table Permission |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
Value | Label | State |
---|---|---|
1 | Active | 0 |
2 | Inactive | 1 |
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- mspp_createdbyName
- mspp_createdbyYomiName
- mspp_modifiedbyName
- mspp_modifiedbyYomiName
- mspp_parententitypermissionName
- mspp_websiteidName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_createdbyname |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_createdbyyominame |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_modifiedbyname |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_modifiedbyyominame |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_parententitypermissionname |
MaxLength | 400 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_websiteidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Listed by SchemaName.
Same as the mspp_entitypermission_parententitypermission many-to-one relationship for the mspp_entitypermission table/entity.
Property | Value |
---|---|
ReferencingEntity | mspp_entitypermission |
ReferencingAttribute | mspp_parententitypermission |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | mspp_entitypermission_parententitypermission |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- mspp_entitypermission_parententitypermission
- mspp_systemuser_mspp_entitypermission_createdby
- mspp_systemuser_mspp_entitypermission_modifiedby
- mspp_website_mspp_entitypermission
See the mspp_entitypermission_parententitypermission one-to-many relationship for the mspp_entitypermission table/entity.
Added by: System Solution Solution
See the mspp_systemuser_mspp_entitypermission_createdby one-to-many relationship for the systemuser table/entity.
Added by: System Solution Solution
See the mspp_systemuser_mspp_entitypermission_modifiedby one-to-many relationship for the systemuser table/entity.
See the mspp_website_mspp_entitypermission one-to-many relationship for the mspp_website table/entity.
Relationship details provided where the mspp_entitypermission table is the first table in the relationship. Listed by SchemaName.
IntersectEntityName: mspp_entitypermission_webrole
Property | Value |
---|---|
IntersectAttribute | mspp_entitypermissionid |
IsCustomizable | False |
LogicalName | mspp_entitypermission |
NavigationPropertyName | mspp_entitypermission_webrole |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
Property | Value |
---|---|
LogicalName | mspp_webrole |
IntersectAttribute | mspp_webroleid |
NavigationPropertyName | mspp_entitypermission_webrole |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |