Seeing Data from a View in SmartList

(0) Share

Report

Posted on by Community Member

Hello:

I created a view in SQL and placed it in a GP company database.

I was able to pull the data into SmartList through SmartList Designer.

Afterward, I ran the following script in SQL against the company database:

GRANT SELECT ON [VIEW] TO DYNGRP

At that point, only "sa" could see the data from the view.

So, I next ran grant.sql against the company database.

Now, administrative users in GP can see the data from the view in SmartList. But, there is one non-administrative user who cannot.

I find this all very odd, because I have created views before and pulled them into GP successfully for all users to see, usually by running grant.sql. Most of the time, I use SmartList Builder, rather than SmartList Designer, but…

How can I get all users to see the data?

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

Hello:

Actually, the solution was pretty simple. All I had to do was access the GP Security Task tied to the user and grant access to the SmartList.

So, it wasn’t that my view was not available to be seen. It was more of a matter of granting access to the SmartList.

Thank you!

John

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi John,

Glad you found it.. Yes.. definitely GP security.. check out this thread on GPUG.. spot on.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, Beat!

John

Was this reply helpful? Yes No