Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Table Permissions Framework reference [AX 2012]

Updated: April 9, 2012

Applies To: 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.

This section lists all database tables that are TPF-enabled by default in Microsoft Dynamics AX and the authorization requirements for those tables.

ImportantImportant

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.