| Talheedin 2006-03-30, 9:32 am |
| Hi Everyone,
I'm still having a bit of trouble with my security settings. I've
used the dynamic dimension security that Deepak suggested (thanks
Deepak) which was:
Filter([Dim1].[Field1].Members,
UserName = [Dim1].CurrentMember.Properties("UserName"))
with a username field in Dim1 as a member property of Field1.
Enforcement is on the server. All security is set up on the cube role
and not the database role.
And when I use the Test Role button at the bottom of the Manage Roles
dialog box it works just fine. Showing only the data that the user has
access to.
However, when we try and access the cubes with our web based front end
(using OWC) or through an ODBC connection in Excel we can see all the
members of Dim1 Field1 instead of just the few members that our test
user should be able to see.
I've checked the msmdqlog table and the test user is logged as the
one who is accessing the cube. There is only one role and the test user
is not in any groups who have administrative rights.
Please help.
|