web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SmartList not displayi...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    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 on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans