Field Security Profile (FieldSecurityProfile) table/entity reference

Artikel
08/31/2024

Profile which defines access level for secured attributes

Messages

The following table lists the messages for the Field Security Profile (FieldSecurityProfile) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Create` Event: True	`POST` /fieldsecurityprofiles See Create	Create records
`Delete` Event: True	`DELETE` /fieldsecurityprofiles(fieldsecurityprofileid) See Delete	Delete records
`Retrieve` Event: False	`GET` /fieldsecurityprofiles(fieldsecurityprofileid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: False	`GET` /fieldsecurityprofiles See Query data	Query data
`Update` Event: True	`PATCH` /fieldsecurityprofiles(fieldsecurityprofileid) See Update	Update records
`Upsert` Event: False	`PATCH` /fieldsecurityprofiles(fieldsecurityprofileid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Field Security Profile (FieldSecurityProfile) table.

Property	Value
DisplayName	Field Security Profile
DisplayCollectionName	Field Security Profiles
SchemaName	`FieldSecurityProfile`
CollectionSchemaName	`FieldSecurityProfiles`
EntitySetName	`fieldsecurityprofiles`
LogicalName	`fieldsecurityprofile`
LogicalCollectionName	`fieldsecurityprofiles`
PrimaryIdAttribute	`fieldsecurityprofileid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`OrganizationOwned`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

Description
FieldSecurityProfileId
Name

Description

Property	Value
Description	Description of the Profile
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	`description`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

FieldSecurityProfileId

Property	Value
Description	Unique identifier of the profile.
DisplayName	Field Security Profile
IsValidForForm	False
IsValidForRead	True
LogicalName	`fieldsecurityprofileid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

Name

Property	Value
Description	Name of the profile.
DisplayName	Name
IsValidForForm	False
IsValidForRead	True
LogicalName	`name`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

ComponentState
CreatedBy
CreatedOn
CreatedOnBehalfBy
FieldSecurityProfileIdUnique
IsManaged
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OrganizationId
OverwriteTime
SolutionId
SupportingSolutionId
VersionNumber

ComponentState

Property	Value
Description	For internal use only.
DisplayName	Component State
IsValidForForm	False
IsValidForRead	True
LogicalName	`componentstate`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`componentstate`

ComponentState Choices/Options

Value	Label
0	Published
1	Unpublished
2	Deleted
3	Deleted Unpublished

CreatedBy

Property	Value
Description	Unique identifier of the user who created the profile.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the profile was created.
DisplayName	Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the role.
DisplayName	Created By Impersonator
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

FieldSecurityProfileIdUnique

Property	Value
Description	For internal use only.
DisplayName	Field Security Profile
IsValidForForm	False
IsValidForRead	True
LogicalName	`fieldsecurityprofileidunique`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

IsManaged

Property	Value
Description	Indicates whether the solution component is part of a managed solution.
DisplayName	Is Managed
IsValidForForm	False
IsValidForRead	True
LogicalName	`ismanaged`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`ismanaged`
DefaultValue	False
True Label	Managed
False Label	Unmanaged

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the profile.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the profile was last modified.
DisplayName	Modified On
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the profile.
DisplayName	Modified By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Unique identifier of the associated organization.
DisplayName	Organization
IsValidForForm	False
IsValidForRead	True
LogicalName	`organizationid`
RequiredLevel	SystemRequired
Type	Lookup
Targets	organization

OverwriteTime

Property	Value
Description	For internal use only.
DisplayName	Record Overwrite Time
IsValidForForm	False
IsValidForRead	True
LogicalName	`overwritetime`
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

SolutionId

Property	Value
Description	Unique identifier of the associated solution.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	True
LogicalName	`solutionid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

SupportingSolutionId

Property	Value
Description	For internal use only.
DisplayName	Solution
IsValidForForm	False
IsValidForRead	False
LogicalName	`supportingsolutionid`
RequiredLevel	None
Type	Uniqueidentifier

VersionNumber

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_fieldsecurityprofile_createdby
lk_fieldsecurityprofile_createdonbehalfby
lk_fieldsecurityprofile_modifiedby
lk_fieldsecurityprofile_modifiedonbehalfby
lk_fieldsecurityprofile_organizationid
solution_fieldsecurityprofile

lk_fieldsecurityprofile_createdby

One-To-Many Relationship: systemuser lk_fieldsecurityprofile_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_fieldsecurityprofile_createdonbehalfby

One-To-Many Relationship: systemuser lk_fieldsecurityprofile_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_fieldsecurityprofile_modifiedby

One-To-Many Relationship: systemuser lk_fieldsecurityprofile_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_fieldsecurityprofile_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_fieldsecurityprofile_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_fieldsecurityprofile_organizationid

One-To-Many Relationship: organization lk_fieldsecurityprofile_organizationid

Property	Value
ReferencedEntity	`organization`
ReferencedAttribute	`organizationid`
ReferencingAttribute	`organizationid`
ReferencingEntityNavigationPropertyName	`organizationid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

solution_fieldsecurityprofile

One-To-Many Relationship: solution solution_fieldsecurityprofile

Property	Value
ReferencedEntity	`solution`
ReferencedAttribute	`solutionid`
ReferencingAttribute	`solutionid`
ReferencingEntityNavigationPropertyName	`solution_fieldsecurityprofile`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

FieldSecurityProfile_SyncErrors
lk_fieldpermission_fieldsecurityprofileid

FieldSecurityProfile_SyncErrors

Many-To-One Relationship: syncerror FieldSecurityProfile_SyncErrors

Property	Value
ReferencingEntity	`syncerror`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`FieldSecurityProfile_SyncErrors`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

lk_fieldpermission_fieldsecurityprofileid

Many-To-One Relationship: fieldpermission lk_fieldpermission_fieldsecurityprofileid

Property	Value
ReferencingEntity	`fieldpermission`
ReferencingAttribute	`fieldsecurityprofileid`
ReferencedEntityNavigationPropertyName	`lk_fieldpermission_fieldsecurityprofileid`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Many-to-Many relationships

These relationships are many-to-many. Listed by SchemaName.

applicationuserprofile
systemuserprofiles_association
teamprofiles_association

applicationuserprofile

See applicationuser applicationuserprofile Many-To-Many Relationship

Property	Value
IntersectEntityName	`applicationuserprofile`
IsCustomizable	False
SchemaName	`applicationuserprofile`
IntersectAttribute	`fieldsecurityprofileid`
NavigationPropertyName	`applicationuserprofile`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

systemuserprofiles_association

See systemuser systemuserprofiles_association Many-To-Many Relationship

Property	Value
IntersectEntityName	`systemuserprofiles`
IsCustomizable	False
SchemaName	`systemuserprofiles_association`
IntersectAttribute	`fieldsecurityprofileid`
NavigationPropertyName	`systemuserprofiles_association`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

teamprofiles_association

See team teamprofiles_association Many-To-Many Relationship

Property	Value
IntersectEntityName	`teamprofiles`
IsCustomizable	False
SchemaName	`teamprofiles_association`
IntersectAttribute	`fieldsecurityprofileid`
NavigationPropertyName	`teamprofiles_association`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Dela via