topic Re: What is the difference between OSUSER() and NTNAME in qlikview? in QlikView

What is the difference between OSUSER() and NTNAME in qlikview?

ananyaghosh — Sat, 27 Jun 2015 05:46:02 GMT

hi,

I want to use section access in my application. I want that a particular user cannot see some object and some particular user will not see some data. How how can I implement this in QlikView?

I have 'CountryID' field and I want that when SANDIP will logged in he can see 1 and when admin logged in he will see all the listed values.

For data reduction I have used the following script:-

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, %CountryID

ADMIN, ADMIN, ADMIN123, *

USER, SANDIP, SANDIP123, 1

];

Section Application;

LOAD * INLINE [

%CountryID, CountryID

1, 1

2, 2

3, 3

];

But for both user I am viewing all the countryid in the list box.

Thanks,

Sandip Ghosh

Message was edited by: Sandip Ghosh

Re: What is the difference between OSUSER() and NTNAME in qlikview?

Gysbert_Wassenaar — Sat, 27 Jun 2015 06:04:20 GMT

See Sheet level access and Section Access and Sheet Permissions‌. You can use the same technique for other objects like charts.

Re: What is the difference between OSUSER() and NTNAME in qlikview?

Anonymous — Sat, 27 Jun 2015 06:36:27 GMT

Hi Sandip,

Please go through this thread: Section Access OsUser() different to Ntname

Re: What is the difference between OSUSER() and NTNAME in qlikview?

prabhas277 — Sat, 27 Jun 2015 07:52:19 GMT

For examples 3 users are A,B,C now user A and User B will see the data and User C will not able to see the data for that purpoes we have to provide the section access,and section application.

section access--building the the security for data

setion application-allowing the user what to see and what not to see..

section access:

access userid,password

admin,admin,admin

user,user1,user2

user,user2,user2

section application

userid,omit

admin,"*"

user1,'A'

user2 'B'

using this will able to see the A and B users only.

Re: What is the difference between OSUSER() and NTNAME in qlikview?

swuehl — Sat, 27 Jun 2015 08:05:15 GMT

Seems like the focus of your post has shifted with your last edit.

Maybe this will help you to implement section access with data reduction:

Introduction to Section Access

I believe %CountryID field name must be upper case to work: %COUNTRYID, also note that star symbol means 'all listed values' (with section access), not all possible values of that field. If you want ADMIN to see everything, remove the star from %COUNTRYID field in section access.

Re: What is the difference between OSUSER() and NTNAME in qlikview?

ananyaghosh — Sat, 27 Jun 2015 10:39:26 GMT

You give me very wrong answer. section access section hold the OMIT field and section application does not hold it.

Thanks,

Sandip

Re: What is the difference between OSUSER() and NTNAME in qlikview?

ananyaghosh — Sat, 27 Jun 2015 10:41:55 GMT

Hi,

I have used the below script:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN123,

USER, SANDIP, SANDIP123,

USER, SANDIP123, SANDIP123

];

Section Application;

LOAD * INLINE [

CountryID, USERID

1, ADMIN

2, ADMIN

2, SANDIP

3, SANDIP123

];

instead of using capital %COUNTRYID, in section access I have used CountryID, USERID fields in application section. and it works. But whenever I have put the * instead of mentioning the COuntryId value, in list box * is appearing.

Any solution of it?

Re: What is the difference between OSUSER() and NTNAME in qlikview?

ananyaghosh — Sat, 27 Jun 2015 10:43:41 GMT

Hi,

I have used the below script:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN123,

USER, SANDIP, SANDIP123,

USER, SANDIP123, SANDIP123

];

Section Application;

LOAD * INLINE [

CountryID, USERID

1, ADMIN

2, ADMIN

2, SANDIP

3, SANDIP123

];

Any solution of it?

Re: What is the difference between OSUSER() and NTNAME in qlikview?

swuehl — Sat, 27 Jun 2015 10:48:00 GMT

You are using the star symbol in field CountryID in section application?

I believe there is no special meaning for that symbol in that section, it's just a field value.

Re: What is the difference between OSUSER() and NTNAME in qlikview?

ananyaghosh — Sat, 27 Jun 2015 10:52:07 GMT

Then how can I make use of showing all values to admin using one shot?

Re: What is the difference between OSUSER() and NTNAME in qlikview?

swuehl — Sat, 27 Jun 2015 10:58:52 GMT

Just have a look into the sample I've attached above.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, %COUNTRYID

ADMIN, ADMIN, ADMIN123,

USER, SANDIP, SANDIP123, 1

];

Section Application;

LOAD * INLINE [

%COUNTRYID, CountryID

1, 1

2, 2

3, 3

];

Re: What is the difference between OSUSER() and NTNAME in qlikview?

ananyaghosh — Sat, 27 Jun 2015 11:04:43 GMT

Ok,Then I have to use %COUNTRYID as a reference field in section access area in script. Otherwise it wil not work. Right?