dbTalk Databases Forums  

Custom Role Security

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


Discuss Custom Role Security in the microsoft.public.sqlserver.olap forum.



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

Default Custom Role Security - 07-22-2004 , 04:02 PM






Problem: Cube1 has Dimension1 and some measures.

We want to restrict access to Dimension1 based on a
custom security model.

Cube2 has Users and Dimension1 dimensions and a single
measure equal to 1 if the user has access to the Cube2
Dimension1.

What would you put in dialog at Cube Role Manager,
Restricted Dimensions, Dimension1 Custom Settings,
Advanced tab, Allowed Members field so Cube1 queries
would only return tuples the UserName is authorized to
view?


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.