SystemUserAuthorizationChangeTracker table/entity reference (Microsoft Dataverse)

Internal authorization table to track user authorization changes

Messages

The following table lists the messages for the SystemUserAuthorizationChangeTracker 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
Associate Event: True	Associate records	Associate records
Disassociate Event: True	Disassociate records	Disassociate records

Properties

The following table lists selected properties for the SystemUserAuthorizationChangeTracker table.

Property	Value
DisplayName	SystemUserAuthorizationChangeTracker
DisplayCollectionName	SystemUserAuthorizationChangeTrackers
SchemaName	SystemUserAuthorizationChangeTracker
CollectionSchemaName	SystemUserAuthorizationChangeTrackers
EntitySetName	systemuserauthorizationchangetrackers
LogicalName	systemuserauthorizationchangetracker
LogicalCollectionName	systemuserauthorizationchangetrackers
PrimaryIdAttribute	systemuserid
TableType	Standard
OwnershipType	None

Writable columns/attributes

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

SystemUserId

Property	Value
Description	Unique identifier for the user
DisplayName	User
IsValidForForm	False
IsValidForRead	True
LogicalName	systemuserid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

Read-only columns/attributes

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

• ChangedOn
• ChangedVersionNumber
• ComputedOn
• ComputedVersionNumber
• SystemUserIdName
• SystemUserIdYomiName

ChangedOn

Property	Value
Description	Date and time when the column ChangedVersionNumber was changed.
DisplayName	Changed On
IsValidForForm	True
IsValidForRead	True
LogicalName	changedon
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ChangedVersionNumber

Property	Value
Description	Database time stamp when user authorization settings were changed
DisplayName	ChangedVersionNumber
IsValidForForm	True
IsValidForRead	True
LogicalName	changedversionnumber
RequiredLevel	SystemRequired
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

ComputedOn

Property	Value
Description	Date and time when the column ComputedVersionNumber was changed.
DisplayName	Computed On
IsValidForForm	True
IsValidForRead	True
LogicalName	computedon
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ComputedVersionNumber

Property	Value
Description	Database time stamp when user authorization data were started recompute
DisplayName	ComputedVersionNumber
IsValidForForm	True
IsValidForRead	True
LogicalName	computedversionnumber
RequiredLevel	SystemRequired
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

SystemUserIdName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	systemuseridname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

SystemUserIdYomiName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	systemuseridyominame
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

Many-to-One relationships

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

user_userauthztracker

One-To-Many Relationship: systemuser user_userauthztracker

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	systemuserid
ReferencingEntityNavigationPropertyName	systemuserid_userauthztracker
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.

• systemuserauthorizationchangetracker_AsyncOperations
• systemuserauthorizationchangetracker_BulkDeleteFailures
• systemuserauthorizationchangetracker_MailboxTrackingFolders
• systemuserauthorizationchangetracker_PrincipalObjectAttributeAccesses
• systemuserauthorizationchangetracker_ProcessSession
• systemuserauthorizationchangetracker_SyncErrors

systemuserauthorizationchangetracker_AsyncOperations

Many-To-One Relationship: asyncoperation systemuserauthorizationchangetracker_AsyncOperations

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

systemuserauthorizationchangetracker_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure systemuserauthorizationchangetracker_BulkDeleteFailures

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

systemuserauthorizationchangetracker_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder systemuserauthorizationchangetracker_MailboxTrackingFolders

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

systemuserauthorizationchangetracker_PrincipalObjectAttributeAccesses

Many-To-One Relationship: principalobjectattributeaccess systemuserauthorizationchangetracker_PrincipalObjectAttributeAccesses

Property	Value
ReferencingEntity	principalobjectattributeaccess
ReferencingAttribute	objectid
ReferencedEntityNavigationPropertyName	systemuserauthorizationchangetracker_PrincipalObjectAttributeAccesses
IsCustomizable	True
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

systemuserauthorizationchangetracker_ProcessSession

Many-To-One Relationship: processsession systemuserauthorizationchangetracker_ProcessSession

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

systemuserauthorizationchangetracker_SyncErrors

Many-To-One Relationship: syncerror systemuserauthorizationchangetracker_SyncErrors

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

See also

Dataverse table/entity reference
Dataverse Web API Reference
systemuserauthorizationchangetracker