Table Permission (mspp_entitypermission) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Added by: Power Pages Apps Solution
Messages
| 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 |
CreateRequest or Create |
| CreateMultiple | CreateMultiple | CreateMultipleRequest |
| Delete | DELETE /mspp_entitypermissions(mspp_entitypermissionid) See Delete |
DeleteRequest or 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 |
RetrieveRequest or Retrieve |
| RetrieveEntityChanges | RetrieveEntityChangesRequest | |
| RetrieveMultiple | GET /mspp_entitypermissions See Query Data |
RetrieveMultipleRequest or 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 |
UpdateRequest or Update |
| UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
| ValidateRetentionConfig | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. |
Properties
| 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 |
Writable columns/attributes
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
mspp_accountrelationship
| Property | Value |
|---|---|
| Description | |
| DisplayName | Account Relationship |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_accountrelationship |
| MaxLength | 1000 |
| RequiredLevel | None |
| Type | String |
mspp_append
| 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 |
mspp_append Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
mspp_appendto
| 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 |
mspp_appendto Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
mspp_contactrelationship
| Property | Value |
|---|---|
| Description | |
| DisplayName | Contact Relationship |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_contactrelationship |
| MaxLength | 1000 |
| RequiredLevel | None |
| Type | String |
mspp_create
| 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 |
mspp_create Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
mspp_createdby
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
mspp_createdon
| 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 |
mspp_delete
| Property | Value |
|---|---|
| Description | Controls whether the user can delete a record. |
| DisplayName | Delete |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_delete |
| RequiredLevel | None |
| Type | Boolean |
mspp_delete Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
mspp_entitylogicalname
| Property | Value |
|---|---|
| Description | |
| DisplayName | Table Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_entitylogicalname |
| MaxLength | 250 |
| RequiredLevel | ApplicationRequired |
| Type | String |
mspp_entityname
| 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 |
mspp_entitypermissionId
| Property | Value |
|---|---|
| Description | Unique identifier for entity instances |
| DisplayName | Table Permission |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | mspp_entitypermissionid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
mspp_modifiedby
| 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 |
mspp_modifiedon
| 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 |
mspp_parententitypermission
| Property | Value |
|---|---|
| Description | |
| DisplayName | Parent Table Permission |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_parententitypermission |
| RequiredLevel | None |
| Targets | mspp_entitypermission |
| Type | Lookup |
mspp_parentrelationship
| Property | Value |
|---|---|
| Description | |
| DisplayName | Parent Relationship |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_parentrelationship |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
mspp_read
| Property | Value |
|---|---|
| Description | Controls whether the user can read a record. |
| DisplayName | Read |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_read |
| RequiredLevel | None |
| Type | Boolean |
mspp_read Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
mspp_scope
| Property | Value |
|---|---|
| Description | |
| DisplayName | Access Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_scope |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
mspp_scope Choices/Options
| Value | Label | Description |
|---|---|---|
| 756150000 | Global | |
| 756150001 | Contact | |
| 756150002 | Account | |
| 756150003 | Parent | |
| 756150004 | Self |
mspp_websiteid
| 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 |
mspp_write
| Property | Value |
|---|---|
| Description | Controls whether the user can update a record. |
| DisplayName | Write |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspp_write |
| RequiredLevel | None |
| Type | Boolean |
mspp_write Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
statecode
| Property | Value |
|---|---|
| Description | Status of the Table Permission |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
statecode Choices/Options
| Value | Label | DefaultStatus | InvariantName |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
statuscode
| Property | Value |
|---|---|
| Description | Reason for the status of the Table Permission |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
statuscode Choices/Options
| Value | Label | State |
|---|---|---|
| 1 | Active | 0 |
| 2 | Inactive | 1 |
Read-only columns/attributes
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
mspp_createdbyName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspp_createdbyname |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
mspp_createdbyYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspp_createdbyyominame |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
mspp_modifiedbyName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspp_modifiedbyname |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
mspp_modifiedbyYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspp_modifiedbyyominame |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
mspp_parententitypermissionName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspp_parententitypermissionname |
| MaxLength | 400 |
| RequiredLevel | None |
| Type | String |
mspp_websiteidName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspp_websiteidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
One-To-Many Relationships
Listed by SchemaName.
mspp_entitypermission_parententitypermission
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 |
Many-To-One Relationships
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
mspp_entitypermission_parententitypermission
See the mspp_entitypermission_parententitypermission one-to-many relationship for the mspp_entitypermission table/entity.
mspp_systemuser_mspp_entitypermission_createdby
Added by: System Solution Solution
See the mspp_systemuser_mspp_entitypermission_createdby one-to-many relationship for the systemuser table/entity.
mspp_systemuser_mspp_entitypermission_modifiedby
Added by: System Solution Solution
See the mspp_systemuser_mspp_entitypermission_modifiedby one-to-many relationship for the systemuser table/entity.
mspp_website_mspp_entitypermission
See the mspp_website_mspp_entitypermission one-to-many relationship for the mspp_website table/entity.
Many-To-Many Relationships
Relationship details provided where the mspp_entitypermission table is the first table in the relationship. Listed by SchemaName.
mspp_entitypermission_webrole
IntersectEntityName: mspp_entitypermission_webrole
Table 1
| Property | Value |
|---|---|
| IntersectAttribute | mspp_entitypermissionid |
| IsCustomizable | False |
| LogicalName | mspp_entitypermission |
| NavigationPropertyName | mspp_entitypermission_webrole |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
Table 2
| Property | Value |
|---|---|
| LogicalName | mspp_webrole |
| IntersectAttribute | mspp_webroleid |
| NavigationPropertyName | mspp_entitypermission_webrole |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
See also
Dataverse table/entity reference
Web API Reference
mspp_entitypermission EntityType
피드백
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요. https://aka.ms/ContentUserFeedback
다음에 대한 사용자 의견 제출 및 보기