Set up toolbox users [AX 2012]

Updated: September 11, 2014

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


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: