Denying Access to a Whole Dimension - by Christopher Webb

Status : 


Sign in
to vote
ID 233410 Comments
Status Active Workarounds
Type Suggestion Repros 3
Opened 10/30/2006 5:31:10 AM
Access Restriction Public


In AS2K it was possible to deny access to an entire dimension (and not just the members on the dimension) using a role. This is no longer possible in AS2005 - all you can do is use dimension security to hide all the members and then create a perspective where the dimension is hidden for users of that role - but this is hardly satisfactory. See for more background.
Sign in to post a comment.
Posted by SQL akuten on 2/26/2015 at 2:41 AM
Any news in this matter?
Posted by Nestor Jarquin on 10/21/2013 at 11:16 AM
I have to say this would be a nice feature to bring back. There are cases where this is highly needed, adding an extra layer of security, which cannot be implemented right now.
Posted by NilsRottgardt on 9/3/2013 at 2:37 AM
Any updated regarding this case? It is a very important feature for large environments, because perspectives cannot be used for handling access to the dimensions.

Kind regards,
Nils Rottgardt
Posted by Microsoft on 3/23/2011 at 4:02 PM

This is not something we'll be able to deliver for SQL11, but are considering for a future version.

Posted by JBergman on 2/2/2011 at 5:58 AM
Did the look you took result in anything?
Posted by Microsoft on 5/23/2008 at 8:56 AM
Thanks Christopher for reporting this.

We are going to take a look at this for the future version

Edward Melomed