Forum Discussion
Service not refreshing/loading a specific field
I think GilbertQ is on to something regarding permissions.
To see definitions in sys.sql_modules a user needs to be granted VIEW DEFINITION in sql server. In your case you'd want to do that at schema level at least for the account running the gateway.
Hi GilbertQ,
Thanks for your reply!
1. Reset to defaults: It was even greyed out, so nothing to reset
2. Upload without refresh: The data is shown.
2a. Gateway access to sys.modules: All other fields/colums are refreshed except that specific ("definition") field/column so it doesn't seem access related? I will try with my own user in the data gateway to see if that solves the problem.
Community ChampionI think GilbertQ is on to something regarding permissions.
To see definitions in sys.sql_modules a user needs to be granted VIEW DEFINITION in sql server. In your case you'd want to do that at schema level at least for the account running the gateway.
That's it indeed!
In my case I went to the properties of the SQL Server user >> Securables >> Permission >> "View any definition".
Thanks bcdobbs and GilbertQ!