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:
-
On the Microsoft Dynamics GP menu, point to
Tools, point to Setup, point to
System, and then click Security Tasks. -
In the Security Task Setup window, in the
Task ID box, type a task identifier (ID). -
In the Task Name box, type a task name.
-
In the Task Description box, type a description.
-
In the Category list, click
System. -
In the Product list, click
SmartList Builder. -
In the Type list, click SmartList Builder Permissions.
-
In the Series list, click
SmartList Builder. The Access List area displays the various permissions for SmartList Builder. -
Click to select the check box next to View SmartLists with SQL Tables.
-
Click Save.
-
Close the Security Task Setup window.
SmartList Builder Security
-
On the Microsoft Dynamics GP menu, point to
Tools, point to SmartList Builder, point to
Security, and then click SQL Table Security. -
On the left side, click the check box next to the database name for which you are receiving the error.
-
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
-
On the Tools menu, point to
SmartList Builder, point to Security, and then click User Security. -
In the SmartList User Security window, click User Security.
-
In the User ID list, click the user who is receiving the error message that is mentioned in the "Symptoms" section.
-
In the Roles area, click to select the check box next to the View SmartLists with SQL Tablesoption.
-
If you are using user classes, click User Class Security, and then repeat step 4.
-
Click OK to save the changes.
SmartList Builder Security
-
On the Tools menu, point toSmartList Builder, point to Security, and then click
SQL Table Security. -
On the left side, click the check box next to the database name for which you are receiving the error.
-
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. -
Repeat step 2 and 3 for views if you have a view used in the SmartList Builder object.
