Field Security Profile (FieldSecurityProfile) table/entity reference

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

See also

Dataverse table/entity reference
Dataverse Web API Reference
fieldsecurityprofile