dbTalk Databases Forums  

Cube Role isn't not working properly

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


Discuss Cube Role isn't not working properly in the microsoft.public.sqlserver.olap forum.



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

Default Cube Role isn't not working properly - 02-21-2005 , 12:46 PM






Hi,

My scenario is:

Win2K Server
AS SP3A
IIS Basic Authentication and "Log on locally" for all application
users

I have a cube where I disabled the Everyone role and created one that
allows "Unsrestricted Read" for the group "APP_Users". This group
contains the user "Test", who is neither an OLAP Administrator nor an
machine Administrator. After that the "Test" user was able to see any
data but not to change, as expected. Hovewer, after I added another
role, that contains only the user "Test", with the following
configuration:

Cell Security Police: Advanced

Read: Unsrestricted
Read Contingent: Unsrestricted
Read/Write: a given subcube (according to an MDX definition)

the "Teste" user became able to writeback in cells that were out of
the subcube defined in the MDX.

Besides, to debbug I changed the Read/Write to "Fully Restricted" but
with a very strange behaviour, the "Test" user was still able to
writeback in those cells.

I've already worked with Roles and Cells Security, though I have no
more idea what can be wrong.

I'd appreciate any help.

Thanks in advance,

Vinicius Bellino

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.