OWC Security - urgent!!!

[shyam_chatty]

Hi all

comin to the issue directly..
i got SP3 of AS with SQL Server 2000 on P4..
i created cubes and dimensions form the SQL database..
i created two db roles, Manager and Team member and given access to
specific users in our NT domain..
some of the members identified in the roles doesnt belong to the
persons table in the database. But this is ok as the role in which i
included them(manager) doesnt have any restrictions either on
cube/dimension/cell level.
The other role(team member) has restrictions based on their NT login, it
validates their name in the persons table and displays only the data
that belong to their name..

All the aboveis working fine if i create OWC pivot table with specific
roles, i.e., i have to create two reports one based on team member and
another based on manager.. i tried to include both the roles in the same
pivot report (in the connection string properties).. but i'm not gettin
the desired results..
Have i missed anything??please help ASAP.. further i've removed
anonymous access in the IIS to enable only NT authentication..

Thanks in advance..reply ASAP