SmartList not displaying results for a user, user can see other SmartLists without issue

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have a user who can not see results for a Purchasing SmartList that calls a view. I can see results as sa just fine. The user can see results from other Purchasing SmartLists on this company database. The user can see the results from this SmartList on other company databases.

The initial reason the SmartList returned no results was because the view used the SmartList Id was missing from the database. I added it, and I am able to view it, but the user is not.

Things I tried but did not resolve the issue:

1) The view only calls tables in the GP company database, which the user has access to as a member of DYNGRP.

2) Tools->SmartList Builder->Security->SQL Table Security

I clicked on the company database and selected the checkbox next to the view used by the SL Task.

3) Tools->Setup->System->Security Tasks

For the SLB security task assigned to the user ->SmartList->SmartList Object->SmartList Object,

I selected Mark All to give access to all smart list object operations.

4) Tools->Setup->System->Security Tasks

For the SLB security task assigned to the user ->SmartList Builder->SmartList Builder Permissions->SmartList Builder,

Checked View SmartLists with SQL Tables

This has to be a permission issue. Any insight on where the permission needs to be set?

*This post is locked for comments

All responses (5)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: SmartList not displaying results for a user, user can see other SmartLists without issue

What ultimately allowed the user to view records through the SmartList view was to add the following database role permissions to the view:

GRANT SELECT,UPDATE,INSERT,DELETE

ON [dbo].[vwPM_Payments_by_Vendor_with_Invoices] TO DYNGRP
Community Member Microsoft Employee on at

Like (0)

Report

RE: SmartList not displaying results for a user, user can see other SmartLists without issue

I was finally able to resolve this by removing the company from the User Access, removing user from the company in ms sql server, and then re-adding company for user. I had to go through and reset all the permissions, however.
Community Member Microsoft Employee on at

Like (0)

Report

RE: SmartList not displaying results for a user, user can see other SmartLists without issue

Wow, caution. I ran this script with 'use <company db>' at the top, and now whenever any DYNGRP tries to log in, I receive the error:

"A get/change first operation on table 'coProcess' failed accessing SQL data."

Looking this up, it suggests changing the passwords, which I did, no change. I blanked out the passwords on the server, re-created password upon login for test user and no change.

This is affecting the step where the user tries to log into a company database, and it is affecting all the companies, instead of just the one I ran the script against.

When the user logs in, it generates the above error. If you try to log in again, it gives the error that the user is already logged on. you have to delete them from user activity before they can try to log in again, but they get the above get/change error.

I
Community Member Microsoft Employee on at

Like (0)

Report

RE: SmartList not displaying results for a user, user can see other SmartLists without issue

I get the following error:

Cannot find the user 'DYNGRP', because it does not exist or you do not have permission.

I did bring up properties of the view on the company database he can see, and the DYNGRP has permissions set up in there, but the one that he can't see does not have these permissions set up. So the view permissions are exactly the key.

I found the script to change the view permissions for DYNGRP at www.gp-dynamics.com/dynamics-gp-command-details.asp
Ian Grieve 22,782 on at

Like (2)

Report

RE: SmartList not displaying results for a user, user can see other SmartLists without issue

It sounds like you need to grant select permissions to DYNGRP on the view.

In SQL Server Management Studio run the following command

GRANT SELECT ON view_name TO DYNGRP