Hi,

I have added a cube role to my sales cube with IND\abcd as
a user.
I want to connect to the cube over HTTP.
I am displaying the data interactively in a OWC pivot
table component on a web page.
The connection string i am using is
"Provider=msolap;Data Source=http://servername;Initial
Catalog=FoodMart 2000;User ID=IND\abcd;pwd=abcd"
The user abcd(from domain IND) has access to some of the
measures but not all.
But when i access the page in which i have embedded the
OWC pivot table , i can see all the measures whereas for
that particular user i should be able to see only a few
measures.
On my client m/c i already have PTS.(Pivottable services)
Te html page is in a virtual dir on the server on which
the directory security is set to Integrated Windows
Aunthentication.

Please help me out
Thanks in advance.
Regards,
Sampada

Sampada,
Log on to the web page with windows authentication using the ind\abcd user
account. Your current security context is probably mapped to the admin
group.

Jon Jahren

"Sampada" <sampkhare (AT) hotmail (DOT) com> wrote

Typically I recommend that you first validate/setup security in
client-server; then implement http access. It just makes things easier.
What do you see if you go the Analysis server, and log in interactively to
the ind\abcd user account and then connect to the cube?
Or you can place the MDX sample application as a shortcut on your desktop --
then when you right-click on it, you will have an option called "Run As.."
and you can specify ind\abcd as the account that you want to run the MDX
sample app under.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jon Jahren" <nospam_jon (AT) softscenario (DOT) no> wrote