Page 1 of 1

Problem with Security Cube setting

Posted: Thu Aug 06, 2009 10:29 am
by kennyyeung
I have a dimension level Security Cube
}ElementSecurity_Customer

I granted the corresponding right to the client Sales1 .
So that Sales1 can view and edit the Cube. [Attached screen shot]

I can manually update the cube with READ , WRITE ,ADMIN ,LOCK...etc
However , if i create a proccess to cellPuts the value , the following error exist

Code: Select all

CellPutS ('READ','}ElementSecurity_Customer','Others_228','Sales1');
Error: Prolog procedure line (5): Execution was aborted. No Security Access for "CellPutS".

Did anyone try this before ?

Re: Problem with Security Cube setting

Posted: Thu Aug 06, 2009 3:02 pm
by kennyyeung
solved
just right click the proccess tick security access

Re: Problem with Security Cube setting

Posted: Thu Aug 06, 2009 10:48 pm
by paulsimon
Ken

You could also try ElementSecurityPut. As you probably know values in security cubes always don't take effect immediately. You are probably safe enough writing a value in to the cube, but a rule derived value generally requires a SecurityRefresh before it becomes active. The slightly odd thing about ElementSecurityPut is that, at least in 9.1.4 it appears to create the security, eg if you use the Element Security Dialog Box, you can see the effect of it, however, if you view the }ElementSecurity cube, the cell appears blank. I tended to do an ElementSecurityPut to be sure that the security will take effect immediately, and then do an ElementSecurityGet and a CellPutS of the value in to the ElementSecurity cube so that I can see the current situation whichever way I decide to view security.

Regards


Paul Simon