.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSAS security safe method assembly

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server


        Any one pls tel me im using Permission as unrestricted in SSAS assembly. The following query is executing but when i use Permission as Safe in SSAS assembly it is not working.

Please tell me about Safe Permission in SSAS assembly.

How to use Safe permission in SSAS assembly.



View Complete Post

More Related Resource Links

Test Run: Determining .NET Assembly and Method References


Before you can test any software system effectively, you must understand the system under test. If the system includes the Microsoft® . NET Framework, understanding the system under test includes understanding its assembly and method dependencies.

James McCaffrey

MSDN Magazine March 2006

Getting filtered data from Role based SSAS security

Hi everyone,I've got a heap of reports that are based on various SSAS cubes. I have roles defined on these cubes that restrict data via certain dimensions. Question is, will these restrictions filter through to the report...ie, if I have a sales person restricted in the SSAS cube to only see sales against their territory (restricted in the Territory dimension), when they run the report will it filter the result based on their SSAS credentials and only show the data they have access to (even though the SSRS report has no direct filters or parameters applied)?Cheers for any help!!

.NET Assembly Security

Hi all, just a quick question.Since there is a .NET Reflector written by LR which disassemble an exe/dll file, i can't find anything nor a better solution to get secure.How are we suppose to write a secure .NET app since it can be disassemble ?Is there a way to do it ? or perhaps possibility ?Or what's your recommendation / suggestion?Regards,David [.NET NEWBIES]

How to call assembly in SSAS

Hi,   Any pls tell me how to call assembly in SSAS.   i want steps to call the assembly I want to write decryption logic in assembly. Then i want to call the assembly in SSAS. Please any one help to solve the issue. Thanks, Abdul2010    

BCS Method Security / External Content Type Permissions / Custom List Security Provider / Security T


I have an external list setup with the usual CRUD methods.  The external SQL table is also being populated by another source.  I want to enable/disable deleting depending on whether the record was created from SharePoint.  I would also like the normal list permissions to work.  So if a user has permissions to delete on the list, they can only delete items created for SharePoint. 

Where should this logic be incorporated?  On the BCS Delete method, somewhere in the External Content Type or on the list instance?  Most examples I find relate to security trimming for search.  I'm only concerned about the delete method.

I'm sure there are multiple ways to accomplish this.  Which is the best?


Best way to implement security for measures in SSAS


Hi SSAS gurus,


I have a requirement where I need to implement security on some measures such that it is visible to a set of users and not accessible to another set of users. Now, I also have SSRS reports defined on top of these measures which are accessible by both the set of users. I want the reports to be displayed such that the measures should be visible to the users with access but invisible or N/A should be displayed when the other set of users access the reports. What would be the best way to go forward for this?

Cheers, Jason 

Are non-static objects thread-safe in a static-method?


I am using javascript and ajax to call server side mothod.  The pagemethod can only be static function in teh server side.  But i know static methods are not thread safe across simultaneous sessions.  However, what if the static method is modifying a non-static object?

for example:

public partial class default : system.web.ui.page

Hero Superman; // create an object called superman of class hero for all user sessions independently

public static int(newpowers)


Superman.powers = newpowers;  // Is this thread safe?  Will each user not accidentally get written by another user's power values?


Calling Assembly in SSAS


Hi Experts,

Im using

While using the below MDX query im facing the below error.


select security_new.StoredProcedures.security_enc(1) on 0 from EncryptedCube

Executing the query ...
Execution of the managed stored procedure security_enc failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException.
The System.Data.SqlTypes.SqlInt32 type cannot be converted to an MDX type.

SSAS 2008 - Security Architecture Design?


Hi, I would like to know BEST way to design SSAS 2008 security architecture for my organization.

I have different data sources in SQL Server 2008 and those ETL store data into datawarehouse (dimension, fact) and then I create cube on that dw. What I want to do is BEST way to desgin SECURITY architecture to browse cube as per ORGANIZATION CHART.

Like we have different companies >>> divided into Division >>> SubDivisions >>> Business Stream >>> Region (i.e. west, east) >>> .....

For example if person has WEST REGION access than he can only see WEST region not the other region but he need access to correct COMPANY >> DIVISON >> SUBDIVISION >> BUSINESS STREAM >> REGION - WEST only.

Please someone can provide BEST possible solution/ideas to design this sort of SECURITY architecture. Thank You.

SSAS 2005 Standard Edition dimensional data security

I am trying to setup a security role that will be based on specific values in a dimension.  We are currently using 2005 SSAS Standard edition.  Does standard edition allow this or will we need Enterprise edition?  This is not working when we test this out.

Method 'X' in type 'Y' from assembly 'Z...' does not have an implementation.


Please note that I posted this previously:


I received an answer and marked it as resolved, but the fix only worked for a very short time, and now it's back to the same problem and never works. I have a WCF 3.5 service hosted in IIS that works fine on Windows 2003 but always breaks in Windows 7 (IIS 7.5) with this message: "Method 'X' in type 'Y' from assembly 'Z...' does not have an implementation." This error message is wrong, because the implementation is there. If I comment out the referenced method, the error simply moves on to the next method. But everything is correct and it works fine in 3 win03 environments.

This is driving me crazy, so it would be heroic of somebody to give me a permanent fix for this. Everything suggested in the previous post (see link above) has been tried, tweaked, retried, restarted, rebooted, etc. Nothing seems to work, not even sporadically anymore.

Thanks in advance for your help.


Need help setting up a Custom Security Trimmer, CheckAccess method not working.


I'm implementing the custom security trimmer for SharePoint server as outlined here: http://msdn.microsoft.com/en-us/library/ee819923.aspx

I have been able to successfully deploy the solution on to the server, but know I need to write the script that will check whether users have access to particular documents or not. The code in the walk-through is the following:

public BitArray CheckAccess(IList<String> documentCrawlUrls, IDictionary<String, Object> sessionProperties, IIdentity passedUserIdentity)
            BitArray retArray = new BitArray(documentCrawlUrls.Count);
            //Use passedUserIdentity to get the identity of the user who issued the query.
            IClaimsIdentity claimsIdentity = (IClaimsIdentity)passedUserIdentity;
           //IClaimsIdentity is defined in Microsoft.IdentityModel.Claims;
            for (int x = 0; x < documentCrawlUrls.Count; x++)

Exception occured in ExecuteOnChannel: System.Security.SecurityException: That assembly does not all

I developed a Web Part solution package for SharePoint 2010 and got the following exception:

10/29/2010 04:02:42.37     w3wp.exe (0x16B8)                           0x19D8    SharePoint Portal Server          User Profiles                     et8h    High        Exception occured in ExecuteOnChannel: System.Security.SecurityException: That assembly does not allow partially trusted callers.     at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)     at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)     at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)     at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibi

Connection issue SSAS 2008 (role security)


Hello Experts,

After implement role security based on dimension security we get connection issues at the initial log on to our ssas cube.

Our environment is:
Windows Server 2008 SP2, x64
MS SQL Server 2008 Enterprise SP1
VM-Ware Maschine
Processor: AMD Opteron 8381 HE (QuadCode 2,5GHz)
Memory: 8 GB
Relation database: about 18 GB
Multidimensional database: about 8 GB / 39 Dimension / 68 measure groups (some were needed to implement m:n relations)

Security model: 4 fact tables get 4 additional column e.g. Security1 with values “yes” and “no”. A Role1 e.g. is able to see Security1 only “yes” facts. A Role2 e.g. is able to see Security2 only “yes”

SSAS 2008 R2 security issue


I have a development server running Windows Server 2008 R2 with a Analysis Services 2008 R2 service running on it. But before going forward with releasing to production, I have one final issue and it's security.

I have two Analysis db roles created: one which has full access (Role1) and another to read the (only) cube and read dimensions and so forth (Role2). When a user is in Role1, the user can see the Analysis database and cubes, etc, but if I remove the user from Role1 and leaving them only in Role2 without full control, the user can no longer even see the Analysis database.

The user can connect to the SSAS instance whether member of either roles which makes me think there are no networking issues. Running a trace I see the user correctly being identified and when the user is in Role1, everything is fine so I don't think it's a possible authentication issue. It's worth mentioning that I have Kerberos configured and working properly as I can tell. But for trying to fix this problem, I'm logged into the server and running SSMS.

QQ, Halp?

About SSAS security on Windows server 2008


Hi Experts:

I set up a role on SSAS cube, and only users in this role can see/process the cube.

And I tried to test it by removing my NT account from not only membership of role on this cube but also administrator group of Win Server 2008R2. The problem is, when I use Excel 2007 to connect the cube on my local PC, I can still see/process this cube...

My NT account is not longer in role's memebership list or Server's administrator group, but why I can still access it...

Any thoughts?  Your help would be greatly appreciated, thanks!

SSAS Assembly Error: The main assembly has the same public key


I've created a CLR Analysis Server assembly that uses the ADOMD Client DLL. When I import the Assembly into my AS Server I don't receive any errors. But when I attempt to call the assembly I receive a #Error as the return. Hovering over the error it says that it can't find the Microsoft.AnalysisServices.AdomdClient.

When I try to add the ADOMD Client DLL, I get "The main assembly has the same public key as the components installed by SQL Server Setup, you cannot use it as the main file in a CLR Assembly Object. (Microsoft.AnalysisServices)"

So looks like a Catch 22 to me. What am I missing? If AS detects that the assembly already exists in the server, why doesn't it simply use the one that is installed instead of throwing the 2nd error stating that I can't import it either???

Clearly I am missing something in my interpretation of the error, has anyone ever seen this before and how can I get around the problem???

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend