Set up toolbox users
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
Some features of Retail use a Microsoft ActiveX control that requires direct access to the Microsoft Dynamics AX database. Only users who have specific database permissions can access the following features:
Till layouts
Form layout
Button grids
Item images
Item bar codes
Language-specific item descriptions
Retail point of sale (POS) operations
Sales tax overrides
Payment types
This topic assumes that you have installed Microsoft SQL Server Reporting Services on the Microsoft Dynamics AX database server, and that the SQL Server settings comply with Payment Card Industry (PCI) standards. For more information about PCI compliance, see Implementation Guide for PCI Compliance.
For each user of Microsoft Dynamics AX who should have access to these features, follow these steps in SQL Server Management Studio.
Create a new SQL Server logon in the Microsoft Dynamics AX database by using Windows authentication and the user’s Windows logon ID.
On the Securables page, grant the user Delete, Insert, Select, and Update permissions to the following tables:
RETAILBUTTONGRID
RETAILBUTTONGRIDBUTTONS
RETAILFORMLAYOUT
RETAILIMAGES
RETAILTILLLAYOUT
Grant the user Select permission to the following tables:
INVENTTABLE
INVENTTXT
INVENTITEMBARCODE
RETAILOPERATIONS
RETAILSALESTAXOVERRIDE
RETAILSALESTAXOVERRIDEGROUPMEMBER
RETAILSTORETABLE
RETAILSTORETENDERTYPETABLE
RETAILTERMINALCUSTOMFIELD