topic Re: Case 906 Control access why work when reload on my note book ? in QlikView

Case 906 Control access why work when reload on my note book ?

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

Hi All

My access control script below work fine when i do reload on my note book :-

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, SOURCE
ADMIN, DESKTOP-9837GT0\pauly,*
ADMIN, QV-PC\QV,TS,TS
];
SECTION APPLICATION;

Work fine mean :-
On my Note book osuser() = DESKTOP-9837GT0\pauly , for SOURCE field i can view SOURCE = ALL
On another note book osuser() = QV-PC\QV , for SOURCE field i can only view SOURCE = TS.

But whem i reload at my another note book osuser() = QV-PC\QV , it does not work , because :-

On my Note book osuser() = DESKTOP-9837GT0\pauly , for SOURCE field i can only view SOURCE = TS
On another note book osuser() = QV-PC\QV , for SOURCE field i can only view SOURCE = TS.

Hope some one can share with me where go wrong ?

Paul Yeo

Re: Case 906 Control access why work when reload on my note book ?

Miguel_Angel_Baeyens — Wed, 24 Jun 2020 11:02:03 GMT

This has been posted multiple times (here, here and here, among many, many others), and it is detailed too in the Help site.

In short: the "*" in the section access table does not mean "all values" but instead "all listed values in the section access table".

That is, since in your section access table code below you only have listed TS in the SOURCE field, "*" refers to TS and TS only.

You will need as many lines in the section access table as possible values you want to use with "*".

Re: Case 906 Control access why work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 11:23:51 GMT

Hi Sir

You are very clear and precise in your explanations. Thank you so much.

Paul

Re: Case 906 Control access why work when reload on my note book ?

paulyeo11 — Mon, 29 Jun 2020 06:27:16 GMT

Hi Miguel_Angel_Baeyens

I have create below sales can only view SOURCE = TS TA TP TI . But all below beside able to view SOURCE = TS TA TP TI , Also can view SOURCE = SD PW PO DA LE ? ( which is not correct )

USER, ROGER\Roger Wee,TS
USER, ROGER\Roger Wee,TA
USER, ROGER\Roger Wee,TP
USER, ROGER\Roger Wee,TI

USER, DESKTOP-K8C67RI\aipeng,TS
USER, DESKTOP-K8C67RI\aipeng,TA
USER, DESKTOP-K8C67RI\aipeng,TP
USER, DESKTOP-K8C67RI\aipeng,TI

USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TS
USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TA
USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TP
USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TI

May i know where go wrong.

Below is admin access right , can view all SOURCE.

ADMIN,DESKTOP-9837GT0\pauly,TS
ADMIN,DESKTOP-9837GT0\pauly,TA
ADMIN,DESKTOP-9837GT0\pauly,TP
ADMIN,DESKTOP-9837GT0\pauly,TI
ADMIN,DESKTOP-9837GT0\pauly,SD
ADMIN,DESKTOP-9837GT0\pauly,PM
ADMIN,DESKTOP-9837GT0\pauly,LE
ADMIN,DESKTOP-9837GT0\pauly,PW
ADMIN,DESKTOP-9837GT0\pauly,DA

Hope you can advise me where go wrong ?

Paul Yeo