Hi there,

in SQL2000 Analysis Services I used a very complex script to authenticate as
a specific user/role to create offline graphs and Pivot-Table pictures via
script for users concerning their own security rights.

I read out the role of this user and used the security settings within this
role to filter the owc-element so that the user only gets to see the
elements/data he is allowed to. This was necessary since the script (DTS) was
run with administrative rights and therefore had access to all data.

I built a serverside OWC, applied the security-filtering, exported to excel
or picture and sent it via email as subscription.

now for the question:

Is there any way to tell a script to use a specific role when accessing the
cube in SQL2005. Is there some kind of "impersonation" mode to see the cube's
data just as a specific user would?

It really should be possible, since there is the functionality available in
Sharepoint to subscribe to reports to be sent to the user or in SSAS Designer
where I can Browse the cube using a specific role for testing ... how does
security impersonation work there?

An answer would be really appreciated since I dont want to re-write a
massive bunch of code for SQL2005

Greetings Monte

Anybody an idea?

"Monte" wrote:

Hi,

the answer was quite easy and can be found here:

http://forums.microsoft.com/MSDN/Sho...80482&SiteID=1

Greetings Monte

"Monte" wrote: