Hello,

env : windows 2000
serveur Sp3
analysis services :
8.0.760
mdxsample : 8.0.194

I have a problem
with security in
analysis services.
I created a role
which contains one
user and which has
a simple restriction
on one member of the
phase dimension.
When I test the role
in analysis manager
, it works,
but when I execute a
request in mdxsampl
it returns all
members of the phase
dimension:

select
{phase.members} on
columns,
{measures.members}
on rows
from reel

thanks for your help

Is the user in the OLAP Administrators group?
OLAP Adminstrators can see all structures regardless of security settings.
"Test role" restricts access by using the "ROLES=<role under test>" on the
connectstring -- otherwise you would see everything as an administrator.
Try it again with a normal user.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"eko" <nospam (AT) nospam (DOT) com> wrote