Section Access only works for ADMIN, Not for USER

[roisolberg]

Hi All

I know there was many threads regarding this issue, iv'e been reading for a while but did not find the correct answer for me.

i am trying to use section access, and i managed to restrict the data for the user i want, 

but the rest of the users, can only see all data if i define them as ADMIN

i tried using with a '*' or leave blank, but or i got 'access denied' or got the restriction iv'e made for one user  for all users.

AUTHORIZATION:

LOAD * INLINE [

ACCESS, USERID, COMPANYNAME
ADMIN, DOMAIN\R,
ADMIN, DOMAIN\M,
USER, DOMAIN\BI.MPS,COMPANY A,
USER, DOMAIN\A,COMPANY A,
ADMIN, DOMAIN\BI.FINANCE,
ADMIN, DOMAIN\BI.RND,
ADMIN, DOMAIN\BI.OPERATIONS,
ADMIN, DOMAIN\B,
ADMIN, DOMAIN\E,
ADMIN, DOMAIN\Z,
ADMIN, DOMAIN\BI.SALES,
ADMIN, DOMAIN\S,
ADMIN, INTERNAL\SA_SCHEDULER,

];
Section Application;

*the names were changed for the company's privacy

so, the restriction for BI.MPS is working well, they can see only 'company A'

the rest of the users i changed to ADMIN and it works, but i want to define this properley and make them a 'USER' 

Thanks!! 

[Rodj]

Hi @roisolberg ,

You will need to either create a separate section access table entry for each association or create a link table in section application so that you can associate a single section access record with a single link table record. This might help a little in understanding the scenarios.

Cheers,

Rod