topic Application Access / Section Access in QlikView

Application Access / Section Access

Wed, 08 Sep 2010 17:27:15 GMT

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?

Application Access / Section Access

Anonymous — Wed, 08 Sep 2010 17:34:49 GMT

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.

Application Access / Section Access

Wed, 08 Sep 2010 17:58:57 GMT

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.

Application Access / Section Access

Wed, 08 Sep 2010 18:19:00 GMT

Nevermind. I just found it.

Thanks guys.

Application Access / Section Access

Anonymous — Wed, 08 Sep 2010 18:23:13 GMT

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.

Application Access / Section Access

gyan_srivastava — Fri, 15 Apr 2011 05:18:04 GMT

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

Application Access / Section Access

erichshiino — Sat, 23 Apr 2011 05:32:18 GMT

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

Application Access / Section Access

gyan_srivastava — Mon, 02 May 2011 06:34:03 GMT

Hi Erich,

Thanks for the response .

Under section Application what is F1 and F2

Section

Application;

//sample data

LOAD

* INLINE [

F1, F2

;

Please help.

Application Access / Section Access

erichshiino — Mon, 02 May 2011 12:08:51 GMT

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

Re: Application Access / Section Access

Thu, 13 Oct 2011 19:06:42 GMT

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.