topic Re: Section Access Issue in QlikView

Section Access Issue

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

Dear Experts,

I have two data table as shown below along with section access details

Here

in first table data for user A,B,C & D is available.
in second table data for user A,B & C is available. (D is missing)

Section Access is working fine for user A, B & C.

But user D is not able to access the file due to the data is not available for user D in table 2.

Hence user D is not able to access the data from any of other tables/analysis of the said file.

Is there any way so that user D can access the data of other Tables where data of user is D.

Regards,

Girish.

Re: Section Access Issue

Peter_Cammaert — Tue, 14 Feb 2017 12:46:47 GMT

Add a single connection per user between you section access table and your data model, by reducing the two redundant columns USER1 and USER2 to a single one and creating a linking table (with the same user definitions) in your data model. You may have to redesign your data model to accomodate this security-by-using-a-single-key.

As an alternative, you can add dummy data to Table 2 that has an entry for missing users, but a NULL value in Data_T2. Then you can leave the Section Access table structure as is.

Re: Section Access Issue

Anonymous — Tue, 14 Feb 2017 13:34:33 GMT

You could create spoof users that are present in Table1 but not Table2 Data;

Table1:

LOAD * INLINE [

USER1, Data_T1

A, 100

B, 200

C, 300

D, 400

];

//=====================================================================================================================

Table2:

LOAD * INLINE [

USER2, Data_T2

A, 100

B, 200

C, 300

];

//=====================================================================================================================

Concatenate

SpoofUsers:

Load

USER1 as USER2,

'NoAccessToT2' as Data_T2

Resident Table1

Where not Exists(USER2,USER1);