Security issue using Section Access .

madhubabum — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am providing security with Section access to my application.

While implementing security, we are using excel file as following.

In My section access file, i want read * (because i am also having sub region codes for WEST,NORTH)

Remaining working perfectly, But i want to read sub region codes also while implementing security(With EXCEL).

Note : If i am having 010101,010102,010103,0101..............99.Having like this.

If I logged into WEST , i want to show all the region codes(From 010101 to 010199)

How we can achieve this...?

Re: Security issue using Section Access .

Anil_Babu_Samineni — Wed, 17 Jan 2018 05:23:24 GMT

With in the Field row values it consider as Cell not the Wildcard match. can you try this way?

Section Access;

Load Access, NTNAME, If(WildMatch([Region Code], '01*', '05*'), [Region Code]) as [Region Code] Inline [

Access, NTNAME, Region Code

USER, PRDQLIKSVR\EAST, 010101

USER, PRDQLIKSVR\WEST, 01*

USER, PRDQLIKSVR\NORTH, 05*

USER, PRDQLIKSVR\WEST, 020201

];

Security Application;