Section Access Issue

[girish_talele]

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.

[Peter_Cammaert]

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.

[Anonymous]

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);