dbTalk Databases Forums  

Security Roles

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


Discuss Security Roles in the microsoft.public.sqlserver.olap forum.



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

Default Security Roles - 04-12-2005 , 01:20 AM






I have a cube with 1 role defined. People belonging to this role can
view data and those not cannot view the data. Each night the Analysis
Service is restarted. Each morning Users who belong to this access
role cannot access the cube. I see that the cube is processed and I
(Admin) can view the cube. When I process the complete database, then
users belonging to the access role can view cube data. Anybody have an
idea how I can solve this problem?

sql2000 with Service pack 3a

thanks in advance

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

Default RE: Security Roles - 04-22-2005 , 06:24 AM






Hi,

I have the same problem. To workaround this I edit the access role and then
users belonging to the access role can view cube data.

Anybody have a solution to solve this problem definitively ?

Thanks.

"Koehly47" wrote:

Quote:
I have a cube with 1 role defined. People belonging to this role can
view data and those not cannot view the data. Each night the Analysis
Service is restarted. Each morning Users who belong to this access
role cannot access the cube. I see that the cube is processed and I
(Admin) can view the cube. When I process the complete database, then
users belonging to the access role can view cube data. Anybody have an
idea how I can solve this problem?

sql2000 with Service pack 3a

thanks in advance


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.