Hi,

When my user is member of 2 roles and when the Role A give access to
everything while the Role B restrict the access to some dimension /
attributes.

which one is the "default" role?
or there is no choice its a cumulative security?

If a user starts Excel (or any other tool), then the Role B should be used
by default without specifying it, when the user access the cube using
another tool (which is my own interface) I use the Role A. (I can force the
role used by adding it in the connectionstring)

my users are connected thrrough HTTP while my application use a direct
connection. Can I change something in the msmdpump.ini file?

Thanks.

Jerome.