AS 2005: better tool for role management?

#1

Hi all,

do you know a tool for role management in AS2005 cubes
which has more and better functionality than SSMS?

E.g. for getting all roles for a user you have to open
each role manually and have a look which users are as-
signed to it.

thanx for your help,
Gerald

#2

Not really, you could always write custom XMLA code rather than using the
UI.

"Gerald Aichholzer" <gerald.aichholzer (AT) gmx (DOT) net> wrote

Quote:

Hi all,

do you know a tool for role management in AS2005 cubes
which has more and better functionality than SSMS?

E.g. for getting all roles for a user you have to open
each role manually and have a look which users are as-
signed to it.

thanx for your help,
Gerald

#3

Have you tried using dynamic security?

On Nov 17, 12:42 am, Gerald Aichholzer <gerald.aichhol... (AT) gmx (DOT) net>
wrote:

Quote:

Hi all,

do you know a tool for role management in AS2005 cubes
which has more and better functionality than SSMS?

E.g. for getting all roles for a user you have to open
each role manually and have a look which users are as-
signed to it.

thanx for your help,
Gerald

#4

Jesse O. wrote:

Quote:

Not really, you could always write custom XMLA code rather than using the
UI.

"Gerald Aichholzer" <gerald.aichholzer (AT) gmx (DOT) net> wrote in message
news:%23yn7lRiCHHA.4312 (AT) TK2MSFTNGP06 (DOT) phx.gbl...

do you know a tool for role management in AS2005 cubes
which has more and better functionality than SSMS?

E.g. for getting all roles for a user you have to open
each role manually and have a look which users are as-
signed to it.

It's not for me, it's for an employee of one of our customers
who has to manage all the roles and does not know anything
about XMLA.

Also I don't know of one XMLA which gives me a list of all
users and the roles they are assigned to. This would be very
handy.

Gerald

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

AS 2005: better tool for role management?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

AS 2005: better tool for role management? - 11-17-2006 , 02:42 AM

Re: AS 2005: better tool for role management? - 11-17-2006 , 11:46 AM

Re: AS 2005: better tool for role management? - 11-18-2006 , 04:34 AM

Re: AS 2005: better tool for role management? - 11-20-2006 , 05:06 AM