Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by 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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Ian Grieve 22,782 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans