Error message when you try to view a SmartList object in Microsoft Dynamics GP: "You do not have security privileges to view all of the tables used in this SmartList”

Applies to: Dynamics GP 2010

Symptoms


When you try to view a SmartList object in Microsoft Dynamics GP or Microsoft Dynamics GP 2010, you receive the error message:
You do not have security privileges to view all of the tables used in this SmartList.

Cause


This problem occurs if one or more of the following conditions are true:
  • You do not have the security privileges that are required to access the table that is used by the SmartList item.
  • You created a SmartList Builder object by using an SQL table.
  • You are running Microsoft Dynamics GP 10.0, and you are using Data Connections.

Resolution


To resolve this problem, verify the following based on the version of Microsoft Dynamics GP that you are using:
  • Verify that the user has the security privileges that are required to view the SQL tables in a SmartList.
  • Verify that the user has access to the table that is used for the object.

Microsoft Dynamics GP 10.0/ Microsoft Dynamics GP 2010

Create a new security task. To do this, follow these steps:
  1. On the Microsoft Dynamics GP menu, point to
    Tools, point to Setup, point to
    System, and then click Security Tasks.
  2. In the Security Task Setup window, in the
    Task ID box, type a task identifier (ID).
  3. In the Task Name box, type a task name.
  4. In the Task Description box, type a description.
  5. In the Category list, click
    System.
  6. In the Product list, click
    SmartList Builder.
  7. In the Type list, click SmartList Builder Permissions.
  8. In the Series list, click
    SmartList Builder. The Access List area displays the various permissions for SmartList Builder.
  9. Click to select the check box next to View SmartLists with SQL Tables.
  10. Click Save.
  11. Close the Security Task Setup window.

SmartList Builder Security

  1. On the Microsoft Dynamics GP menu, point to
    Tools, point to SmartList Builder, point to
    Security, and then click SQL Table Security.
  2. On the left side, click the check box next to the database name for which you are receiving the error.
  3. On the right side, click the check box next to the table/view name that is used by the SmartList Item.

    Note You can also click Mark All to mark all the tables in the company database.

Microsoft Dynamics GP 9.0

  1. On the Tools menu, point to
    SmartList Builder, point to Security, and then click User Security.
  2. In the SmartList User Security window, click User Security.
  3. In the User ID list, click the user who is receiving the error message that is mentioned in the "Symptoms" section.
  4. In the Roles area, click to select the check box next to the View SmartLists with SQL Tablesoption.
  5. If you are using user classes, click User Class Security, and then repeat step 4.
  6. Click OK to save the changes.

SmartList Builder Security

  1. On the Tools menu, point toSmartList Builder, point to Security, and then click
    SQL Table Security.
  2. On the left side, click the check box next to the database name for which you are receiving the error.
  3. On the right side, click the check box next to the table/view name that is used by the SmartList item.

    Note You can also click Mark All to mark all the tables in the company database.
  4. Repeat step 2 and 3 for views if you have a view used in the SmartList Builder object.