Set up toolbox users

  • Article

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.

  1. Create a new SQL Server logon in the Microsoft Dynamics AX database by using Windows authentication and the user’s Windows logon ID.

  2. On the Securables page, grant the user Delete, Insert, Select, and Update permissions to the following tables:

    • RETAILBUTTONGRID

    • RETAILBUTTONGRIDBUTTONS

    • RETAILFORMLAYOUT

    • RETAILIMAGES

    • RETAILTILLLAYOUT

  3. Grant the user Select permission to the following tables:

    • INVENTTABLE

    • INVENTTXT

    • INVENTITEMBARCODE

    • RETAILOPERATIONS

    • RETAILSALESTAXOVERRIDE

    • RETAILSALESTAXOVERRIDEGROUPMEMBER

    • RETAILSTORETABLE

    • RETAILSTORETENDERTYPETABLE

    • RETAILTERMINALCUSTOMFIELD

See also

Set up buttons

Design a screen layout

Set up a button grid