Greetings,

Using Analysis services, I'm trying to generate output that describes
the current security profile of my server. In other words, I'd like to see
what groups or users belong to each cube database and cube role. I started
looking at the DSO object model, but couldn't find what I was looking for.
Is DSO the only way I might be able to do this? thanks.

-Ryan

DSO is the way to go.
Database objects and Cube objects include a Roles collection.
You should begin by looking at these BOL topics:

Role Interface
clsDatabaseRole
clsCubeRole

You can also take a look at the source code of the DSO-XML utility,
available from Microsoft
(http://www.microsoft.com/downloads/d...DisplayLang=en
), that uses these interfaces to export roles to XML.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html


"Ryan" wrote: