Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Nevermind. I just found it.
Thanks guys.
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.
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
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
];
Hi Erich,
Thanks for the response .
Under section Application what is F1 and F2
Section
Application;
//sample data
LOAD
* INLINE [
F1, F2
;
Please help.
Section application means that section access has 'closed'. Everything after that line is already your application.
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.