topic Re: Security and section access in QlikView

Security and section access

Tue, 27 May 2014 08:03:49 GMT

Hello,

I want to limit what data authorized users can see, so I created 3 users that each one see only the Data of one country.

I did like this but I have an error: "Erreur de syntaxe, FROM manquant ou mal placé :

SECURITE_CLIENT:

LOAD * INLINE["

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, GROUPE

ADMIN, ADMIN, ADMIN, GA

USER, USER1, U1, G1

USER, USER2, U2, G2

USER, USER3, U3, G3

];

SECURITE_CLIENT:

LOAD * Inline[

GROUPE, PAYS

GA,*

G1, BELGIQUE

G2, LUXEMBOURG

G3, SINGAPOUR

];

Section Application;

I am waiting for your help plz

Re: Security and section access

Tue, 27 May 2014 09:18:43 GMT

You need a space between Inline and [

SECURITE_CLIENT:

LOAD * Inline [

GROUPE, PAYS

GA,*

G1, BELGIQUE

G2, LUXEMBOURG

G3, SINGAPOUR

];

Re: Security and section access

amit_saini — Tue, 27 May 2014 09:37:22 GMT

Hi Ifthen,

Please see the attachment and use below credentials to open the application :

Username : admin

Password: admin

Thanks,

Re: Security and section access

sasikanth — Tue, 27 May 2014 09:38:05 GMT

Try some thing like this,

Section Access;
LOAD * INLINE
[
    ACCESS, USERID, PASSWORD, GROUPE,PAYS
    ADMIN, ADMIN, ADMIN, GA,*
    USER, USER1, U1, G1,BELGIQUE
    USER, USER2, U2, G2,BELGIQUE
    USER, USER3, U3, G3,SINGAPOUR
];
section Application;

Re: Security and section access

Tue, 27 May 2014 09:43:12 GMT

Hi,

Thank you for your response, the problem now that the security is not applied! all the users can see the data of the 3 countries

The goal is to limit the USERS to the data of one country.

USER1 will only be able to see the data for BELGIQUE, USER2 the data for LUXEMBOURG

and USER3 will only see the datafor the SINGAPOUR country.

Re: Re: Security and section access

jagannalla — Tue, 27 May 2014 09:51:17 GMT

Hi,

Did you checked "Initial Data Reduction Based on Section Access" in document properties

Document properties -> Opening Tab -> Check Initial Data Reduction Based on Section Access

Cheers!!

Jagan

Re: Security and section access

amit_saini — Tue, 27 May 2014 09:52:20 GMT

Hi ,

Please create a excel sheet say for example Section_Application_Plant.xlsx in this case like below you can mention access type and then use the script below:

Here I'm assuming that you are having a qlikview field called Plant in your case which is carrying all countries name in your case , by using this script below and the excel sheet you can restrict users to see plants according to your choice.

Section Access;

Access:

LOAD ACCESS,

NTNAME,

upper(PLANT) as PLANT

FROM

[........\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table is sheet1)

where 1=1;

Section Application;

PlantAccess:

load

upper(PLANT) as PLANT,

PLANT as Plant

FROM

[.......\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table is sheet1)

where 1=1;

Thanks,

Re: Security and section access

sasikanth — Tue, 27 May 2014 10:00:30 GMT

HI Find the Script Below

SECTION Access;
LOAD * Inline [
ACCESS,USERID,PASSWORD,COUNTRY
ADMIN,ADMIN,ADMIN,*
USER,USER1,U1,IN
USER,USER2,U2,ENG
USER,USER3,U3,AUS
];

SECTION Application;

LOAD * Inline [
COUNTRY
IN

ENG
AUS
];
Make sure that u have checked the check box

Document Properties ---> Initial reduction based on section access, Strrict Exclusion

Hope this will help you