Object or sheet level section access - Qlik Community

raju_salmon · ‎2017-02-15

Hi,

I have implemented section access using below thresds and it is working fine while using USERID.

https://community.qlik.com/docs/DOC-4435

https://community.qlik.com/docs/DOC-7327

However if we use NTNAME and approach the same, it is showing error while opening from access point that "Failed to open document. You do not have access"

Even i have found many comment in thread Chart Level Access by user saying that NTNAME is not working for them. But i have not found any solution.

Can anyone help why this approach not working when it comes to NTNAME?

raju_salmon · ‎2017-02-15

I mean NTName is working with desktop, but not from access point.

vardhancse · ‎2017-02-15

Hi,

NTNAME base section access have some condition:

1. System login matches it will open directly

2. If if falls under different domain, it will prompt for ID and password.

Check the system domain as well.

Because in access point the NTNAME will be based on domain.

sasikanth · ‎2017-02-15

Have you tried with NTNAME in you desktop ?, are you able to login ?

Make sure NTNAME should be like: Domain\username.

if not please share your section access script.

raju_salmon · ‎2017-02-15

Using Same.

Domain\username.

Domain\RAJU_S

For me it is working in desktop, but not through access point.

Section Access;

SA:

LOAD ACCESS,

Trim(UPPER(NTNAME)) AS NTNAME,

Trim(UPPER(STORE)) AS STORE

FROM

[..\Data\Section..xlsx]

(ooxml, embedded labels, table is sheet1);

Section Application;

//It is working if i comment below section.// working for only filter store data, not to hide sheets.

SectionAccess:

LOAD

Trim(UPPER(NTNAME)) AS NTNAME,

Sheet2,

Sheet3

FROM

[..\Data\Section.xlsx]

(ooxml, embedded labels, table is sheet1);

sasikanth · ‎2017-02-15

Section Access;

SA:

LOAD ACCESS,

Trim(UPPER(NTNAME)) AS NTNAME,

Trim(UPPER(STORE)) AS STORE

FROM

[..\Data\Section..xlsx]

(ooxml, embedded labels, table is sheet1);

Section Application;

//It is working if i comment below section.// working for only filter store data, not to hide sheets.

SectionAccess: ( Remove this)

LOAD

Trim(UPPER(NTNAME)) AS NTNAME,

Sheet2,

Sheet3

FROM

[..\Data\Section.xlsx]

(ooxml, embedded labels, table is sheet1);

raju_salmon · ‎2017-02-15

Same issue Sasi.

sasikanth · ‎2017-02-15

Would you be able to share your application?

vardhancse · ‎2017-02-15

SECTION ACCESS;

Access:

LOAD

ACCESS,

NTNAME

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Access);

SECTION Application;

star is *;

Security:

LOAD NTNAME,

DEPARTMENT

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Security);

In QMC try to enable below option: