Hi,
i want to use Roles to restrict the displayed data for each user.

To do this, i am using the Dimension Data attribute of the role. For
the restriction i am using a DMX query like the following:

Filter([Dim Mitarbeiter].[Login].Members, [Dim
Mitarbeiter].[Login].CurrentMember.Name = Username)

It is working only when i am using this role in the connection-string.
In this case, the data is filtered correctly.

But the problem is: The user is still able to connect to the database
without using a role. And in this case all cube data is displayed to
him.

How can i force a user to use a role?

I am using Authentication via Active Directoy. I have added the
AD-Account of the calling user to the role. But why is he still able to
connect without using the role?!

Problem was solved with SQL Server 2005 Service Pack 1