Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

confusion about SSAS security Expand / Collapse
Author
Message
Posted Friday, May 10, 2013 4:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:43 PM
Points: 148, Visits: 265
hi everyone
i am quite confused about read contingent security for cube cell data? I know that it is much stricter than read permission and that it applies to calculated members, but not much more

can anyone please explain it further
Post #1451782
Posted Monday, May 13, 2013 2:31 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 1,157, Visits: 3,259
markusstar (5/10/2013)
hi everyone
i am quite confused about read contingent security for cube cell data? I know that it is much stricter than read permission and that it applies to calculated members, but not much more

can anyone please explain it further


Take a look at -

http://www.sqljason.com/2010/04/implementing-measure-security-in-ssas.html

http://msdn.microsoft.com/en-us/library/ms174847.aspx

In my experience cell security often comes at the cost of query performance so avoid if you can


Tommy

Post #1452317
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse