Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Application Access / Section Access

I want to limit the data the user can see based on the user's role. This works for me, but QlikView prompts a username/pwd screen, which is not what I need. I need QlikView to get my NT username and do the thing.

Any example or ideas about how to do this?

9 Replies
Anonymous
Not applicable
Author

Check the refereence manual under section access for more details but...I think you might want



NTNAME



A field that should contain a string corresponding to a Windows

NT Domain user name or group name. QlikView will fetch the

logon information from the OS and compare it to the value in

this field.



Not applicable
Author

The example in the reference manual is two simple and does not cover what I need.

The theory I know, what I need is a code example.

Not applicable
Author

Nevermind. I just found it.

Thanks guys.

Anonymous
Not applicable
Author

OK, can you be more specific about what you need. My understanding is that if you have apprpropriate entries in NTNAME, QV will then prompt the OS rather then prompt you and your users for USERID's / Passwords. I sounded like you wanted to eliminate the prompting for USERID's PASSWORDS.

gyan_srivastava
Contributor III
Contributor III

Hi Igor,

We have similar need . can you share the code that you have found out for NT security . So that user ID and password will not be popped up.

We have urgent requirement .Please help.

Regards

erichshiino
Partner - Master
Partner - Master

Hi,

With the code below I created a hybrid.

You can include some users to be recognized directly (by DOMAIN\USERNAME).

If the user is not on the list, he could still open it by username and password (admin / admin).


SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';
SET DayNames='seg;ter;qua;qui;sex;sáb;dom';

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME
ADMIN, ADMIN, ADMIN, *
ADMIN, , , DOMAIN\USERNAME
];
Section Application;

//sample data

LOAD * INLINE [
F1, F2
1, ab
2, c
3, de
];


gyan_srivastava
Contributor III
Contributor III

Hi Erich,

Thanks for the response .

Under section Application what is F1 and F2



Section

Application;

//sample data

LOAD

* INLINE [



F1, F2

;

Please help.







erichshiino
Partner - Master
Partner - Master

Section application means that section access has 'closed'. Everything after that line is already your application.

Not applicable
Author

Hello Igor,

Can you please let me know how you get the user NT ID, I need this information to restrict information access for certain users and i need to know the NT user .

Can you please provide me the code.

Thanks,

Fernando.