Case 860 How to let user access SOURCE = A1 and A2 data ?

[paulyeo11]

Hi All

My Raw data :-

SOURCE -SALES
A1 - 1
A2 - 2
B1 - 3
B2 - 4

My Load script :-

Directory;
LOAD SOURCE,
SALES
FROM
DATA.xlsx
(ooxml, embedded labels, table is COY_A);

Section Access Script :-

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, SOURCE

ADMIN, domain\UserName,*
USER,domain\UserNameA1,A1
USER,domain\UserNameB1,B1

];

SECTION APPLICATION;

Now i need to let one group of user can Access A1 and A2 SOURCE data.

I try :-

USER,domain\UserNameA,A1&A2

it does not work.

Hope some one can advise me.

Paul Yeo

[Arthur_Fong · Accepted solution]

Try this:

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, SOURCE

ADMIN, domain\UserName,*
USER,domain\UserNameA,A1
USER,domain\UserNameA,A2
USER,domain\UserNameB,B1

];

[paulyeo11]

Hi Sir

Thank you , it work .