News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) GP2015 - Smart list us...

Microsoft Dynamics GP (Archived)

GP2015 - Smart list using SQL view - Permissions?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello,

I have created a view from a SQL statement so that I can use it as part of a Smart List. I was able to create the Smart List using the view while logged in as the SA user, however, I am unable to view the Smart List with my personal user account (This account has "power user" security role). When I try to look at the Smart List nothing loads and the same is true for other users in the system.

What permissions in GP2015 need to be granted for a user to see this data? Would it be within GP only or will they need additional SQL permissions?

Thanks,

Andrew

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: GP2015 - Smart list using SQL view - Permissions?

Worked like a charm - many thanks!
Community Member Microsoft Employee on at

Like (0)

Report

RE: GP2015 - Smart list using SQL view - Permissions?

I will try this later today and report back - thanks for the suggestion!
Verified answer

Tim Wappat 5,701 on at

Like (1)

Report

RE: GP2015 - Smart list using SQL view - Permissions?

I would try:

GRANT SELECT ON {ViewName} to DYNGRP;

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans