dbTalk Databases Forums  

Cube Roles Not Working in Web App

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


Discuss Cube Roles Not Working in Web App in the microsoft.public.sqlserver.olap forum.



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

Default Cube Roles Not Working in Web App - 11-19-2003 , 12:41 AM






Hi, I'm building a web application with ASP.NET to browse cubes using
the PivotTable and ChartSpace components. I'm trying to enforce cube
security so that when an user logs in to windows and opens his
browser, he will only see his cubes. Here's what I've done so far:

1. Created a cube called "Sales" and restricted access to the measure
"amount" to "Everyone".

2. Accesed cube from browser: /localhost/olapTestApp

Now, my problem is that I can see the measure "amount" even when it
has been restricted to all users. Does anyone know what's causing this
odd behavior?

Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default Cube Roles Not Working in Web App - 11-19-2003 , 01:19 AM






Guess the User who is trying to access is not an OLAP
Administrator.

Security Restrictions will not hold if the user is an OLAP
Administrator.

Cheers,
Sanka


Quote:
-----Original Message-----
Hi, I'm building a web application with ASP.NET to browse
cubes using
the PivotTable and ChartSpace components. I'm trying to
enforce cube
security so that when an user logs in to windows and
opens his
browser, he will only see his cubes. Here's what I've
done so far:

1. Created a cube called "Sales" and restricted access to
the measure
"amount" to "Everyone".

2. Accesed cube from browser: /localhost/olapTestApp

Now, my problem is that I can see the measure "amount"
even when it
has been restricted to all users. Does anyone know what's
causing this
odd behavior?
.


Reply With Quote
  #3  
Old   
Alex
 
Posts: n/a

Default Re: Cube Roles Not Working in Web App - 11-19-2003 , 10:17 AM



"Sanka" <loonysan (AT) mailcity (DOT) com> wrote

Quote:
Guess the User who is trying to access is not an OLAP
Administrator.

Security Restrictions will not hold if the user is an OLAP
Administrator.

Cheers,
Sanka


Thanks for your reply Sanka, I just did a test using a different
account to log in to Windows and the cube restrictions worked.


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.