Security and section access

[#1]

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

[#2]

You need a space between Inline and [

SECURITE_CLIENT:

LOAD * Inline [

GROUPE, PAYS

GA,*

G1, BELGIQUE

G2, LUXEMBOURG

G3, SINGAPOUR

];

[amit_saini]

Hi Ifthen,

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

Username : admin

Password: admin

Thanks,

AS

[sasikanth]

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;

[#5]

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.

[jagannalla]

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

[amit_saini]

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,

AS

[sasikanth]

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