Level Wise Security Access

    Hi All,

     

    Please find the level wise Security Access sample document.

    Hope it helps for someone.

     

    SECTION Access;

    LOAD * Inline

    [

    USERID, PASSWORD, ACCESS, %KEY

    A, A, ADMIN, *

    B, B, USER, ANN|BI|QV

    C, C, USER, ANN|*|*

    D, D, USER, BNN|AT|*

    E, E, USER, BNN|BT|SSIS

    ];

     

    SECTION Application;

    Table1:

    LOAD *,L1&'|'&L2&'|'&L3 AS KEY INLINE [

        L1, L2, L3

        ANN, BI, QV

        ANN, BI, TABLEAU

        BNN, AT, MICRO

        BNN, AT, INFORMATICA

        BNN, BT, SSIS

    ];

     

    Table2:

    LOAD Distinct KEY, L1 & '|*|*' AS %KEY Resident Table1;

    Concatenate(Table2)

    LOAD Distinct KEY, L1 & '|' & L2 & '|*' AS %KEY Resident Table1;

    Concatenate(Table2)

    LOAD Distinct KEY, L1 & '|' & L2 & '|' & L3 AS %KEY Resident Table1;

     

     

    User A  can see all the data.

    User B can see the ANN | BI| QV data alone.

    User C can see the ANN details and so on.