topic Re: Dynamic NTName Section Access in QlikView

Dynamic NTName Section Access

NavinReddy — Tue, 28 Apr 2020 11:22:27 GMT

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

Re: Dynamic NTName Section Access

kaushiknsolanki — Tue, 28 Apr 2020 12:42:29 GMT

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.

Re: Dynamic NTName Section Access

NavinReddy — Tue, 28 Apr 2020 17:08:11 GMT

@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

Re: Dynamic NTName Section Access

NavinReddy — Wed, 29 Apr 2020 15:55:05 GMT

@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

Re: Dynamic NTName Section Access

kaushiknsolanki — Fri, 01 May 2020 16:16:08 GMT

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

Re: Dynamic NTName Section Access

NavinReddy — Sat, 02 May 2020 18:51:02 GMT

@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.

Re: Dynamic NTName Section Access

kaushiknsolanki — Sun, 03 May 2020 05:53:03 GMT

You should replace NTNAME with NTSID Field.

And this field should contain your SID.

Re: Dynamic NTName Section Access

NavinReddy — Thu, 07 May 2020 12:25:07 GMT

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

Re: Dynamic NTName Section Access

kaushiknsolanki — Fri, 08 May 2020 04:46:33 GMT

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/manage-security-with-section-access.htm

Re: Dynamic NTName Section Access

Brett_Bleess — Wed, 20 May 2020 15:50:36 GMT

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