Cube security

Question

Cube security

venkatesh.sql

SSC-Addicted

Points: 437
More actions
November 24, 2009 at 1:34 am

#218034

I have a data cube and would like to assign roles on the cube to the users from the users table which has all the users data stored in it. How do I achieve this? Could this be done via Active Directory?
Regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

Role membership can be granted to Windows users. I don't think there is a way to tie your roles back to application level data (user table).

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

venkatesh.sql SSC-Addicted Points: 437 More actions · Answer 2

Please briefly explain how would I achieve this?

Thanks in advance

Regards......

SQLRNNR SSC Guru Points: 281324 More actions · Answer 3

this article may be of help

http://hmorgenstern.spaces.live.com/blog/cns!28A6BE83102A0EB3!270.entry

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

happycat59 One Orange Chip Points: 29384 More actions · Answer 4

Not only can you use Username as part of an MDX expression to filter the set of visible member, you can also call a .net assembly to apply your security rules. The assembly simply needs to be passed whatever relevant parameter (e.g. username, dimension/level name) and it returns a set of members that the user is allowed to see.

This is not documented all that well although there are publication out there that give examples on how to do this. One of my colleagues wrote code to call a SQL Server sproc that handled the rules for each user.