Hi All,
Wondering if someone can help me with this, something that I’ve been battering my head against the last couple of days…
This is on SP2010
We have a list, the items of which get assigned item level permissions so only a monitoring team can view all and then only specific people can see items relating to their own department
We have a MI portal that pulls information from this list into excel, where some charts are created using a pivot table of the data. The people that update this data do not necessarily have access to the items in the list.
We get around this by using creds stored in SSS
The secure store service is configured with an application ID that uses credentials for an account that has full read permissions to the web app and to the content database
And the excel services app has the application ID above specified for its external data connections
When i specify in a data connection to use either the specific application ID or use use the creds stored in SSS its still using the creds of the logged in user to pull the information from the list
I can prove this by connecting to SharePoint as users with differing permissions to the list the connection accesses. Running the data refresh pulls through only the data that user can see, not the whole lot that the service account can see
Any thoughts?
Thanks
Rob
I’ve managed to get around this now by reconfiguring the data connections in the library to use oData connections instead, hitting the listdata.svc of the site.
had to pull in additional lists to match lookup columns so I wasn’t just getting hre ID value through, but it seems to be working well
