issue of NTNAME and NTSID - Qlik Community

Srinivas · ‎2014-01-21

Dear All,

here i faced ntname and ntid issue,

i wrote code like this

load

ACCESS,

NTNAME

from excel path:

but when i reload and open freshly then access denied error showed..... i can't able to open that application.

(i given all restiction also

Initial Data Reduction Based on Section Access Checked
Strict Exclusion Checked
Prohibit Binary Load Checked

)

Second one is

how to use NTSID and implement code please give same codes

Advance

Munna

Siva_Sankar · ‎2014-01-22

Munna,

Not sure about the code. But do find the attachment for sections access. There you can get the information and steps to implement section access with examples.

Regards.

Siva

qlikpahadi07 · ‎2014-01-22

Hi munna,

I don't think it's a trouble may b small mistake from you end check the steps :

Make sure you have added correct NTNAME else your application will not load once reloaded/saved.
No need to check any "Initial Data Reduction" as such that is used when you need to reduce your data with Users to restrict the unauthorized data with users.
load you table between Section Access and Section Application tags.

Example :

Section Access;

LOAD NTNAME,

ACCESS

FROM

Security_Matrix.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

NT SID:

This field must contain a Windows NT SID.

Example: S-1-5-21-125976590-467238106-1092489882-1378

QlikView will fetch the logon information from the OS and compare it to the value in

this field.

Srinivas · ‎2014-01-22

Hi Siva,

when i open user name password region showing correct but some other listboxes showed all values.

Access;
LOAD
    ACCESS,
    Upper(NTNAME) AS USERID,
    PASSWORD,
    Region
FROM
C:\Users\Security.xlsx
(ooxml, embedded labels, table is Sheet1);
Section Application;
LOAD USERNAME as USERID,
    UserGroup,
    GBU ,
     Region
FROM
C:\Users\Group.xlsx
(ooxml, embedded labels, table is Sheet1);

region have----> north, south,east,west

division have -----> Eru, empa, ema,xyd...so on

here when i open username(A) and password then

Region showed only one value (North) it is right but...

Division showed all values like Eru, empa, ema,xyd...so on

but i don't want that User(A) can see only 'Eru' only

so that mean list box will be apper only one like 'Eru'

Thanks

Munna

Srinivas · ‎2014-01-22

Hi phadi,

NTNAME working fine,

Load

Access,

NTSID

from Excel path:

its work can you give sample example.....

in i have excel file that excel file have NTSID as your example way have different values

Thanks Advance

Munna

qlikpahadi07 · ‎2014-01-22

Hi Munna,

well actually I never tried with NTSID i usually go with NTNAME or USER/PASSWORD in almost all clients and works fine and cover all requirements .

ramkrishna86 · ‎2014-01-22

Hi Munna Reddy,

Can you attach your excel sheet so that i can analyse how you have designed your security excel sheet.

RK

Srinivas · ‎2014-01-23

Hi Pahadi,

NTNAME	PASSWORD	ACCESS	NTSID	GRP	USERNAME	Region
bruhdsc1	Hilde De Schryver	USER	S-1-5-21-91305380-190758515-3224351304-4459	BRU	Hilde De Schryver	ALL
bruigro1	Irina Groza	USER	S-1-5-21-91305380-190758515-3224351304-50729	FEA	Irina Groza	APAC
brujram1	Joao Ramalheira	USER	S-1-5-21-91305380-190758515-3224351304-41042	BRU	Joao Ramalheira	LAC
brujvil1	Julien Villatte	USER	S-1-5-21-91305380-190758515-3224351304-10156	BRU	Julien Villatte	LAC
brukkle1	Karen Klerkx	USER	S-1-5-21-91305380-190758515-3224351304-4465	BRU	Karen Klerkx	LAC
brukanr1	Keshwar Anroedh	USER	S-1-5-21-91305380-190758515-3224351304-40981	EMA	Keshwar Anroedh	ALL
brukper1	Kris Peremans	USER	S-1-5-21-91305380-190758515-3224351304-4313	BRU	Kris Peremans	ALL
bruldeg1	Lars De Greef	USER	S-1-5-21-91305380-190758515-3224351304-4311	BRU	Lars De Greef	ALL
bruldre1	Laurent Dresse	USER	S-1-5-21-91305380-190758515-3224351304-40913	SRA	Laurent Dresse	ALL

like this way i have NTSID, Can you help on this

Please help on this if you have any sample code please reply....

Thanks

Munna

Srinivas · ‎2014-01-24

Hi Ram,

I will attached the Excel data please find...

NTNAME	PASSWORD	ACCESS	NTSID	GRP	USERNAME	Region
bruhdsc1	Hilde De Schryver	USER	S-1-5-21-91305380-190758515-3224351304-4459	BRU	Hilde De Schryver	ALL
bruigro1	Irina Groza	USER	S-1-5-21-91305380-190758515-3224351304-50729	FEA	Irina Groza	APAC
brujram1	Joao Ramalheira	USER	S-1-5-21-91305380-190758515-3224351304-41042	BRU	Joao Ramalheira	LAC
brujvil1	Julien Villatte	USER	S-1-5-21-91305380-190758515-3224351304-10156	BRU	Julien Villatte	LAC
brukkle1	Karen Klerkx	USER	S-1-5-21-91305380-190758515-3224351304-4465	BRU	Karen Klerkx	LAC
brukanr1	Keshwar Anroedh	USER	S-1-5-21-91305380-190758515-3224351304-40981	EMA	Keshwar Anroedh	ALL
brukper1	Kris Peremans	USER	S-1-5-21-91305380-190758515-3224351304-4313	BRU	Kris Peremans	ALL
bruldeg1	Lars De Greef	USER	S-1-5-21-91305380-190758515-3224351304-4311	BRU	Lars De Greef	ALL
bruldre1	Laurent Dresse	USER	S-1-5-21-91305380-190758515-3224351304-40913	SRA	Laurent Dresse	ALL

Above one is first excel file...

USERNAME	UserGroup	GBU	Region
Hilde De Schryver	GPE	ALL	ALL
Irina Groza	HKG	ALL	APAC
Joao Ramalheira	JUA	ALL	LAC
Julien Villatte	JUA	ALL	LAC
Karen Klerkx	JUS	ALL	LAC
Keshwar Anroedh	KED	ALL	ALL
Kris Peremans	KED	ALL	ALL
Lars De Greef	LAX	MED	ALL
Laurent Dresse	LAX	MED	ALL

this above one is second excel file... Here i wrote code

Access;
LOAD
    ACCESS,
    Upper(NTNAME) AS USERID,
    PASSWORD,
    Region
FROM
C:\Users\Security.xlsx
(ooxml, embedded labels, table is Sheet1);
Section Application;
LOAD USERNAME as USERID,
    UserGroup,
    GBU ,
     Region
FROM
C:\Users\Group.xlsx
(ooxml, embedded labels, table is Sheet1);

region have----> ALL,APSC,LAC

GBU have ----->ALL,MED...so on

here when i open username(Hilde De Schryver) and password then

Region showed only one value (ALL) it is right but...

GBU showed all values like ALL,MED...so on

but i don't want that, User(Hilde De Schryver) can see only 'ALL' only in GBU part.

Note: this GBU not restricted, Please help on this.......

Thanks

Munna

ramkrishna86 · ‎2014-01-24

Hi Munna,

Code and everything looks good, please don't use "ALL" keyword for giving access to whole GBU or Region. "ALL" keyword will not work on server and gives you access denied error.

Thanks,

RK