star symbol in section access

[gauthamchilled]

hi,

I understand * means all in section access.

i wanted to control access using three field office, region and department.

Star is *;

Section Access;

Section_Access:

LOAD UPPER(NTNAME) as  NTNAME,

  //UPPER(NTNAME) as  USER,

     ACCESS,

     ROLEACCESS,

     UPPER(COUNTRY) AS COUNTRY,

     UPPER(REGION_SA) AS REGION ,

     UPPER(DEPARTMENT) AS DEPT,

      UPPER(OFFICE) AS [OFFICE]

From SA.xls file;

say for example, i give access to one user particular country, and region and i want all the departments in the region to be visible to that person. * not working.

how can i handle this to get possible values of the department in section access.

earlier i used auth key combinations from the example described by HIC. but my application is big and more than 6 fields are in my actual application the key comination creation is taking long time to load.

so i decided to use straight forward approach and star is not woking..

can anyone help to sort out this issue?

Gautham

[arvind_patil]

Hi Gautham,

* Is consider all those  field values which you mentioned in section access file in your case in SA.xls.

If you mentioned in that field all values then only show.

Thanks,

Arvind Patil

[balar025]

Hi Gautham,

I think you have to go with bridge table concept.

For example

Section Access;

Security:

Load * Inline

[

ACCESS,NTNAME,NTCOUNTRY

ADMIN,U1,*

USER,U2,IN

USER,U3,UK

USER,U4,US

]

Section Application;

Country_Bridge:

Load

Country, // tio link with current data model.

Country as NTCOUNTRY

from geo table;

This might help you to over come your issue.

[neha_shirsath]

Refer attached document. Go through it. On page no 16-17 the concept of '*' is given.

[gauthamchilled]

Any help on how to get the possible values under department for the region and office?

[neha_shirsath]

Can you post sample data.