I'm trying to use database roles in a VB6 application using ADO MD.
Even though the roles I've defined works inside the analyse menager I don't
know hot to use them with a ADOMD connection.
I use a connection string like this:
Data source=server;Provider=MSOLAP.2;Initial catalog=database;User
id=domain\user;password=my_password;
and I set
ActiveConnection.Properties("roles") = role_to_use

Is It right? Is there something mpore I have to do?

Thanks
Andrea

The roles you are "member of" is based on your NT Username (remember that AS
always uses NT authentication). Once that set is established, the roles=
parameter on the connectstring can be used to establish a *subset* of those
roles to use in this particular connection. So, for example, if your NT
Username is a member of "Branch Managers", "District Managers" and
"Analysts", then you can use roles=Analysts to only invoke that role for
this connection. See BOL under the topic "PivotTable Service Properties".
--
Dave Wickert [MS]
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.


"Andrea Temporin" <NOSPAM_temporin (AT) encopro (DOT) it> wrote

Now it works, but there is still one thing I don't understand.
If I log to the computer with user John.Smith member of role=Role1 and in my
connection string I set User ID=Ann.Ross with roles=Role2 I see everything
as John.Smith. I can work with Ann.Ross and Role2 only if I log to the
computer as Ann.Ross.
Is it right or is there something more I have to do? Does ADO MD consider
the user name i set in the connection string?

Thanks

Andrea

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Hi Andrea,
AS always uses the current Windows account (perhaps restricted by additional
Roles= in the connection string).
You are able to set username and password in the connection string just and
only if you connect AS via an http connection.

HTH
Frank

"Andrea Temporin" <NOSPAM_temporin (AT) encopro (DOT) it> wrote