dbTalk Databases Forums  

need help with Cube roles

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


Discuss need help with Cube roles in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jermaine Chan
 
Posts: n/a

Default need help with Cube roles - 10-14-2004 , 11:17 AM






I'm currently trying to make information available to users over the
internet and have set up the olap report on iis.
I have defined Cube roles which retricts a certain dimension. is it
possible to make a login system that will match the user with a
certain cube role? Thanks a lot.

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: need help with Cube roles - 10-14-2004 , 02:15 PM






Unfortunately, no. A role must have either a username or a group as members.
The system cannot do automatic mapping -- as an admnistrator you must do it
by-hand. However, there are ways you can script out and then create roles
from the command line -- but you must implement this. Look at using the
DSO/XML tool with it's ability to import/export objects from xml files.

http://www.microsoft.com/downloads/d...DisplayLang=en

--
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.

"Jermaine Chan" <j43chan (AT) uwaterloo (DOT) ca> wrote

Quote:
I'm currently trying to make information available to users over the
internet and have set up the olap report on iis.
I have defined Cube roles which retricts a certain dimension. is it
possible to make a login system that will match the user with a
certain cube role? Thanks a lot.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.