Environment: MOSS 2007, SQL Analysis Server 2008
I have a Web Part that displays a Pivot Table from a Trusted Excel doc. When I open the Dashboard page with this web part, I see correct data. When ANOTHER user does the same, (this user does NOT have ANY permissions to view or browse the base cube)
they see the LAST CACHED VERSION of this Excel Pivot Table from when it was last saved. This happens even if I set the "Refresh Data on opening of file". And I have also see in a SQL Trace that the account that hits the cube is the SharePoint Service account,
NOT the user in question. Should I be concerned?
How do I make it so that if a User does NOT have permissions on the cube, that Excel Services won't show them any data?
Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
View Complete Post