Dynamic Security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: wall.andrew@xxxxxxxxx
Date: 16 Oct 2006 08:12:07 -0700

I need to restrict a dimension and have 150 or so roles that need to be
created. This is obviously a nightmare in terms of maintenance so I am
looking at the Dynamic Security options. I need multiple users in each
role and am struggling with this in terms of the mdx. Can anyone help?

.

Prev by Date: Re: Individual KPI status indicator symbols / RDBMS and MS AS in MS RS
Next by Date: Re: OLAP Design Problem
Previous by thread: Re: Individual KPI status indicator symbols / RDBMS and MS AS in MS RS
Next by thread: sql browser and named instance connection issue
Index(es):
- Date
- Thread

Relevant Pages

RE: Security vs types of data
... Make sure the restricted user has access to the cube. ... Restrict the dimension data to the user in the 'All database dimensions' ...
(microsoft.public.sqlserver.olap)
Re: restrict view to subcube
... if you want to restrict the users to a particular region, apply a security in your dimension. ... I also thought about trying a hidden filter of some kind, ...
(microsoft.public.sqlserver.olap)
Re: restrict view to subcube
... if you have only few regions, create 1 role by region, restrict each role to ... if you have too many regions, try to use a dynamic dimension security scheme ... > filter the cube view for OWC. ... like subcubes would also be a reasonable approach if we can control ...
(microsoft.public.sqlserver.olap)
Re: Cube Role Manager
... With the role you have defined, you restrict the cube to the tuple ... > Dimension Customer Group: ...
(microsoft.public.sqlserver.olap)
Re: How to spoof MAC-address in SuSE Linux?
... > Yes there is or was, Some ISPs would only allow you to connect with a ... They where trying to restrict the use of home networks ... Then it still is illegal use of the MAC adress. ... You are about to enter another dimension, ...
(alt.os.linux.suse)