topic Re: Step required for implementation Section Access in QlikView

Step required for implementation Section Access

shantanu73 — Mon, 04 Feb 2013 05:39:02 GMT

Hello Forums/Friends,

Following Section Access script is implemented for Data Security. As per the script if User login with ADMIN user

he should able to see all records. And If user login without ADMIN user then that user should able to see related records.

But script is not working as per requirments.

SECTION Access;LOAD * Inline [
ACCESS,USERID,PASSWORD,REDUCTION
ADMIN,ADMIN,ADMIN,*
ADMIN,ADMIN1,ADMIN1,*

USER,USER1,USER1,2
USER,USER2,USER2,3
];
SECTION Application;star is *;LOAD * Inline [
REDUCTION,DEPARTMENTID
1,1Computer
2,2Mouse
3,3Keyboard
1,4Harddisk
1,5MousePad
];

Can anybody tell that whether the script is ok. And if it is ok whether anything has to be tick in the propertise.

Thanks in Advance

Shantanu

Re: Step required for implementation Section Access

Anonymous — Mon, 04 Feb 2013 05:47:13 GMT

Hi Shantanu,

Keep in mind that all server connections are considered USER even though the user is listed with ADMIN access in section access.

Also, the * indicates all values in the field that have been listed (in this example 2 & 3).

Re: Step required for implementation Section Access

Anonymous — Mon, 04 Feb 2013 05:54:37 GMT

Hi, your script is ok. You need to check the Initial Data Reduction Based on Section Access on the Opening Tab of the Document Properties. Also practial to uncheck the Remember Login Credentials Until Exit in your User Preferences. Regards, Sander

Re: Step required for implementation Section Access

shantanu73 — Mon, 04 Feb 2013 05:56:06 GMT

Hello Johannes,

In the script the user ADMIN1 should be given as 1, But while copy paste I mistakely putted * instead of 1.

The script should be for recored number 2 as follows:

ADMIN,ADMIN1,ADMIN1,1

Thanks for giving suggession. However it is done. There is parameter which has to be tick in

Document Setting->Opening->Intital Data Reduction Based on Section Access.

Thanks

Shantanu

Re: Step required for implementation Section Access

shantanu73 — Mon, 04 Feb 2013 05:59:33 GMT

Hello Sander,

Thank for response. But it is done.

Thank

Shantanu