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

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 table permis...
Microsoft Dynamics GP (Archived)

Smartlist table permissions

(0) ShareShare
ReportReport
Posted on by Community Member

 I've created a view which combines item master with manufacturer and primary vendor tables.

I then created a smartlist for this combined view. But I can't figure out how to grant permissions to our users, only sa user can use them so far.

 Here's what I have so far.

  • Grant SELECT for public users of the view in MSSQL
  • Smartbuilder SQL table security has the views added (view can be added in smartlist builder)
  • I've granted access to this smarlist object to the targeted users (users can see smartlist)
  • Users have permission to view and edit all the columns in the view involved.

But when they try to look at this smartlist they get the following error and no data.
You do not have permission to view all the tables used in this smartlist.

Is security supposed to be this big of a pain?

Thanks,

 

 

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    If you haven't done so, you need to at least add SELECT permissions on the view for the DYNGRP role specifically. You can find a script named 'GRANT.SQL' in the SQL\UTILS folder inside your GP folder. If you run this script against the company database. it will automatically do this for you for all objects inside that database.

  • Community Member Profile Picture
    Community Member on at

     Thanks for the suggestion, unfortunately I did set that up already.

     All the permissions are there, it just doesn't add up.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    It sounds like you are on GP 10.0.  This may help: http://victoriayudin.com/2008/10/08/granting-access-to-a-new-smartlist-in-gp-10/

    Specifically this section:

    If you are on GP 10.0 and your SmartList is based on SQL views or tables, you will need to add permissions to the View SmartLists with SQL Tables operation.  Here are the settings under Security Tasks:

    • Product: SmartList Builder
    • Type: SmartList Builder Permissions
    • Series: SmartList Builder Permissions or SmartList Builder (depends on the Service Pack)
    • Operations: View SmartLists with SQL Tables
  • Community Member Profile Picture
    Community Member on at

     Thank you very much. That was it.

     I would have never thought to look in smartlist builder security as these users don't need access to it.

  • Community Member Profile Picture
    Community Member on at

    Glad I found this note.  I am working with GP2013, and have created many smartlists with Builder using views over the years, and never had this message regarding permissions on tables.  Then a client wanted to have another user have access to one of these smart lists, and I assigned the task to her, and the message regarding permissions on tables popped up.   Others were using the smartlists just fine.  Assigning the operation "View SmartLists with SQL Tables" as noted above resolved the issue.  I hunted around to see if this operation was assigned by some other task for the other users, but to no avail.    Things work fine now, but I am still puzzled what is the difference.

    Thanks

    Don Pugh

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans