Dynamic NTName Section Access

[NavinReddy]

Hello All,

can some one help me how to make my static NTName section access to Dynamic section access. kindly help me to modify static code to dynamic. 

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME

    USER, NAEAST\U10320

    USER, NAEAST\U40733

    USER, NAEAST\U49612

    USER, NAEAST\U50477

    ADMIN, NAEAST\T01165

];

Section Application;

    LOAD * INLINE [

    NTNAME, SID

    NAEAST\U10320,U10320

    NAEAST\U40733,U40733

    NAEAST\U49612,U49612

    NAEAST\U50477,U50477

    NAEAST\T01165,T01165

    ];

Regards,

Navin

[kaushiknsolanki]

What do you expect us to do? 

Do you even understand what have you asked?

Sorry for being harsh, but you should know how to ask the questions, isn't it?

I request you to provide as much detail as you can about your issue. Use an example to make us understand it. If possible provide the sample data and expected output from that data.

[NavinReddy]

@kaushiknsolanki  sorry for my bad explanation.

i have used below script for build the NTNAME section access, if any updates in future i have to update section access manually. To avoid manual edits,how can i build script based on data changes.  

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME

    USER, NAEAST\U10320

    USER, NAEAST\U40733

    USER, NAEAST\U49612

    USER, NAEAST\U50477

    ADMIN, NAEAST\T01165

];

Section Application;

    LOAD * INLINE [

    NTNAME, SID

    NAEAST\U10320,U10320

    NAEAST\U40733,U40733

    NAEAST\U49612,U49612

    NAEAST\U50477,U50477

    NAEAST\T01165,T01165

    ];

Regards,

Navin

[NavinReddy]

@kaushiknsolanki  with the below script, i have build the dynamic section access. now i have added my name to the excel data list. when im trying to open the application i got the " Access Denied" error message. kindly help in future any additions to the list how can i provide the access to the members. kindly help me

Data:

LOAD Source,

     SID

FROM

[..\Desktop\Section Access\Output.xlsx]

(ooxml, embedded labels, table is Sheet1);

USERACCESS:

LOAD * INLINE [

    ACCESS, NTNAME

    ADMIN,

];

Concatenate

LOAD 'USER' AS ACCESS,

     'NAEAST\'& SID as NTNAME

     RESIDENT Data;

Drop table Data;

Section access;

Load *

Resident USERACCESS;

Section application;

Regards,

Navin

[kaushiknsolanki]

Its because you missed the reduction field.

Your section access should have 3 fields.

1. Access

2. NTName

3.ReductionField. (The field on which you want to restrict the access).

[NavinReddy]

@kaushiknsolanki Thanks for your reply,

Based on SID im restricting the access, could you please suggest me where should i include the SID on script. kindly help me.

[kaushiknsolanki]

You should replace NTNAME with NTSID Field.

And this field should contain your SID.

[NavinReddy]

@kaushiknsolanki sorry for my later reply, still i am unable to figure out the section access issue. kindly help me. i am attaching the section access script and excel file. 

Data:
LOAD Source,
[Review ID],
[Control name],
[Trade Date],
SID,
'NAEAST\'& SID as NTNAME,
[Reviewee Name]
FROM
[..\Desktop\Section Access\Output.xlsx]
(ooxml, embedded labels, table is Sheet1);

USERACCESS:
LOAD * INLINE [
ACCESS, NTNAME
ADMIN,
];

Concatenate
LOAD 'USER' AS ACCESS,
NTNAME
RESIDENT Data;

/* remove data members from memory */
Drop table Data;

/* create section access */
Section access;

Load *
Resident USERACCESS;

Section application;

[kaushiknsolanki]

Dear  NavinReddy,

I told you in my above post that your section access table should have 3 columns.

But in your script, I can see only 2 columns, i.e Access and NTName

Also for Admin, you have not defined the NTNAME in your table.

Due to this both things your script is not working as desired.

Correct them and it will work.

For more help look at the link below.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/mana...

[Brett_Bleess]

Adding one additional Design Blog post for some additional information:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Regards,
Brett