Table Permissions Framework reference
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
The Table Permissions Framework (TPF) enables administrators to set restrictions on tables that store data, including sensitive data. To enable TPF, an administrator specifies a value for the AOSAuthorizationProperty on a specific table in the Application Object Tree (AOT). The AOSAuthorizationProperty can be used to authorize Create, Read, Update, and Delete operations.
For more information, see Manage data access by using the Table Permissions Framework.
Tables
This section lists all database tables that are TPF-enabled by default in Microsoft Dynamics AX and the authorization requirements for those tables.
Important
These tables store sensitive data. We recommend that you do not adjust these authorization requirements, especially in a production environment. Test your changes in a test environment so that you can study the impact on user-role permissions and make adjustments as necessary.
Table name |
Authorization required for |
|---|---|
AifChannel |
Create, Update, Delete |
AifSqlCdcEnabledTables |
Create, Read, Update, Delete |
AifValueSubstitutionComponentConfig |
Create, Read, Update, Delete |
BankAccountTable |
Create, Read, Update, Delete |
BankBillOfExchangeTmp |
Create, Read, Update, Delete |
BankIBSLog_BE |
Create, Read, Update, Delete |
BatchGroup |
Create, Update, Delete |
BatchServerConfig |
Create, Update, Delete |
BatchServerGroup |
Create, Update, Delete |
BIAnalysisServer |
Create, Read, Update, Delete |
BIConfiguration |
Create, Read, Update, Delete |
BIPerspectives |
Create, Read, Update, Delete |
BIUdmTranslations |
Create, Read, Update, Delete |
CompanyInfo |
Create, Read, Update, Delete |
CreditCardCust |
Create, Read, Update, Delete |
CreditCardCustNumber |
Create, Read, Update, Delete |
CreditCardMicrosoftSetup |
Create, Read, Update, Delete |
CreditCardProcessorsSecurity |
Create, Read, Update, Delete |
CustBankAccount |
Create, Read, Update, Delete |
CustVendOutTmp |
Create, Read, Update, Delete |
EPDocuParameters |
Create, Update, Delete |
EPGlobalParameters |
Create, Update, Delete |
EPWebSiteParameters |
Create, Update, Delete |
ExpressionTable |
Create, Update, Delete |
GeneralJournalAccountEntry |
Create, Read, Update, Delete |
HcmPersonIdentificationNumber |
Create, Read, Update, Delete |
HcmWorkerBankAccount |
Create, Read, Update, Delete |
LedgerActivityZakatTmp_SA |
Create, Read, Update, Delete |
LedgerClosingSheet |
Create, Read, Update, Delete |
LedgerMainZakatTmp_SA |
Create, Read, Update, Delete |
LedgerOpeningSheet_ES |
Create, Read, Update, Delete |
LedgerProvisionsTmp_SA |
Create, Read, Update, Delete |
LedgerRevenueActivityTmp_S |
Create, Read, Update, Delete |
LedgerZakatHeaderTmp_SA |
Create, Read, Update, Delete |
NumberSequenceDatatype |
Create, Update, Delete |
NumberSequenceScope |
Create, Update, Delete |
OMUserRoleOrganization |
Create, Update, Delete |
OMUserRoleOrganizationTmp |
Create, Update, Delete |
RetailSetupLog |
Create, Update, Delete |
ShipCarrierSQLRoleUser |
Create, Read, Update, Delete |
SIGCertificateUsage |
Update, Delete |
SIGParameters |
Update, Delete |
SIGProcSetup |
Create, Update, Delete |
SIGProcSetupField |
Create, Update, Delete |
SIGProdStatusChange |
Update, Delete |
SIGReasonCode |
Create, Update, Delete |
SIGReportFinished |
Update, Delete |
SIGSignatureDelegation |
Create, Update, Delete |
SIGSignatureFailure |
Update, Delete |
SIGSignatureLog |
Update, Delete |
SRSAnalysisEnums |
Create, Read, Update, Delete |
SRSEnabledLanguages |
Create, Read, Update, Delete |
SRSModelEntityCache |
Create, Read, Update, Delete |
SRSModelFieldCache |
Create, Read, Update, Delete |
SRSModelFieldRoleSortCache |
Create, Read, Update, Delete |
SRSModelForeignKeyCache |
Create, Read, Update, Delete |
SRSModelIndexCache |
Create, Read, Update, Delete |
SRSModelPerspectiveCache |
Create, Read, Update, Delete |
SRSModelPerspectiveEntityCache |
Create, Read, Update, Delete |
SRSModelPerspectiveFieldCache |
Create, Read, Update, Delete |
SRSModelPerspectiveForeignKeyCache |
Create, Read, Update, Delete |
SRSModelPerspectiveRoleCache |
Create, Read, Update, Delete |
SRSModelRoleCache |
Create, Read, Update, Delete |
SRSModelRoleGroupsCache |
Create, Read, Update, Delete |
SRSReportDeploymentSettings |
Create, Update, Delete |
SRSServers |
Create, Read, Update, Delete |
SRSUpdateOptions |
Create, Read, Update, Delete |
SRSUserConfiguration |
Create, Read, Update, Delete |
SysClusterConfig |
Create, Update, Delete |
SysCompileILTable |
Create, Read, Update, Delete |
SysDataBaseLog |
Update, Delete |
SysExpImpField |
Create, Update, Delete |
SysExpImpTable |
Create, Update, Delete |
SysFileStore |
Create, Update, Delete |
SysFileStoreFile |
Create, Update, Delete |
SysMapParameters |
Create, Read, Update, Delete |
SysPerimeterNetworkParams |
Create, Update, Delete |
SysRecordTemplateSystemTable |
Create, Update, Delete |
SysRemoveConfig |
Create, Read, Update, Delete |
SysRemoveFields |
Create, Read, Update, Delete |
SysRemoveLicense |
Create, Read, Update, Delete |
SysRemoveTables |
Create, Read, Update, Delete |
SysSecurityFormControlTable |
Create, Update, Delete |
SysSecurityFormTable |
Create, Update, Delete |
SysServerConfig |
Create, Update, Delete |
SysSetupCompanyLog |
Create, Update, Delete |
SysSetupLog |
Create, Update, Delete |
SysSignatureSetup |
Create, Update, Delete |
SysSortOrder |
Create, Update, Delete |
SysUserInfo |
Create, Delete |
SysWorkflowElementTable |
Update, Delete |
SysWorkflowFaultTable |
Update, Delete |
SysWorkflowInstanceTable |
Update, Delete |
SysWorkflowTable |
Update, Delete |
SysWorkflowTrackingEntry |
Update, Delete |
SysXppAssembly |
Create, Read, Update, Delete |
Tax1099BoxDetailHistory |
Create, Read, Update, Delete |
Tax1099IRSPayerRec |
Create, Read, Update, Delete |
Tax1099TransmitterParameters |
Create, Read, Update, Delete |
TmpBankBillofExchangePrintout |
Create, Read, Update, Delete |
TmpBankPromissoryNotePrintout |
Create, Read, Update, Delete |
TmpChequePrintout |
Create, Read, Update, Delete |
TrvCreditCards |
Create, Read, Update, Delete |
VendBankAccount |
Create, Read, Update, Delete |
VendCoverPageSignature |
Create, Read, Update, Delete |
VendRequestProspectiveProfile |
Create, Read, Update, Delete |
VendSubcontractorZakatTmp_SA |
Create, Read, Update, Delete |
VendTable |
Create, Read, Update, Delete |
WorkflowActionTable |
Create, Update, Delete |
WorkflowAssignmentTable |
Create, Update, Delete |
WorkflowAssociation |
Create, Update, Delete |
WorkflowElementLinkTable |
Create, Update, Delete |
WorkflowElementNotificationTable |
Create, Update, Delete |
WorkflowElementOutcomeTable |
Create, Update, Delete |
WorkflowElementTable |
Create, Update, Delete |
WorkflowEscalationPathTable |
Create, Update, Delete |
WorkflowEscalationTable |
Create, Update, Delete |
WorkflowMaxRuntimeTable |
Create, Update, Delete |
WorkflowMessageText |
Create, Update, Delete |
WorkflowParallelBranchTable |
Create, Update, Delete |
WorkflowStepTable |
Create, Update, Delete |
WorkflowSubWorkflow |
Create, Update, Delete |
WorkflowSubWorkflowItem |
Create, Update, Delete |
WorkflowSubWorkflowTable |
Create, Update, Delete |
WorkflowTable |
Create, Update, Delete |
WorkflowTimeSpanTable |
Create, Update, Delete |
WorkflowVersionNotificationTable |
Create, Update, Delete |
WorkflowVersionTable |
Create, Update, Delete |
WorkflowVersionTableNotes |
Create, Update, Delete |
xRefNames |
Create, Read, Update, Delete |
xRefPaths |
Create, Read, Update, Delete |
xRefReferences |
Create, Read, Update, Delete |
xRefTableRelation |
Create, Read, Update, Delete |
xRefTmpReferences |
Create, Read, Update, Delete |