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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

User Cannot Access SLB Smartlist

(0) ShareShare
ReportReport
Posted on by 4

It's been a while since I've worked with SmartList Builder andI need some guidance on this issue.  The client is using a SQL view from a non-GP company database (it's from portal that pulls data from GP).  The DYNGRP has select permissions on the view and other users can access the SL without a problem.  There are a couple new GP users that are able to navigate to the Smartlist folder and see the bookmarks/favorites, but no results are produced.

I set myself up as a POWERUSER to test and came up with the same thing - no results.  As expected, sa has no problem running the SL.  

Any idea as to what could be causing this problem?  I'm probably missing something simple, but I'm pretty rusty.  Thanks in advance!

Jim

*This post is locked for comments

I have the same question (0)
  • Jim Lines Profile Picture
    4 on at

    I figured out my issue with the help of this post:  community.dynamics.com/.../54350.aspx , I was able to figure out my issue.   Turns out that the SL was looking at a view in a non-GP db.  My predecessor had granted access to this database to the DYNGRP so it was just a matter of adding the user to that group.  Problem solved.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans