Use custom authorisation on access to cube

Is it possible to use our solution's existing authentication mechanism for determining access rights to a MS Analysis services cube?

We already have a system that manages usage policies and we would like to avoid duplicating this on the SQL Server.

Our authentication system is based on NetSqlAzMan and we could expose it as a web service, or a set of managed .NET assemblies (or just about anything if it got us the above functionality)...

Answers


If you mean Custom Authentication my answer is No. SSAS uses Windows Autentication and you should use it with its services or options (active directory, other integrated solutions etc).

If you mean Custom Authorization then my answer is Yes. Basically, you should follow the steps below;

  • Create a .NET assembly that uses your NetSqlAzMan backed web services or whatever you have for integration.
  • Register the assembly with Analysis Services
  • Use the registered assembly's functions in the advanced Dimension Security section to restrict the dimension members by users.

Custom assembly in this context must be developed as high performant as possible because every MDX query will consult it for filtering the members.


Need Your Help

ListView equivalent to iPhone table default table cell

android listview

Is there an equivalent view structure to the iPhone default table cell? The default table cell formats an image (icon) and text in a nice looking way. Are there suggested equivalents for Android? Is

dot42 jar import is missing methods

android dot42

I imported a jar project in to my dot42 project. It appears to have made a wrapper but it is missing some methods. Any idea what I am doing wrong? The jar is this one: