topic Section access - All access in QlikView

Section access - All access

Mon, 14 Apr 2014 09:52:06 GMT

Dear all,

Some user need to be restricted acces for some branches but most can see all of them.

when I do a little test (see below) the section access definition * doesn't seem to be recognized.

How do I convince Qlikview to allow certain users access to all fields?

Code:

Star is *; // Required if wildcard characters are used in Section Application

// -------------------- Who can access this Application --------------------

Section Access;

[User Authentication]:

Load * Inline [

ACCESS, NTNAME, TCTLOW

ADMIN, SERVER-EU\BE11635, *

User, SERVER-EU\BE11635, 'S010'

];

// -------------------- What filters are enforced per User --------------------

Section Application;

[Branch Authorisation]:

Load

NTNAME,

TCTLOW as [0SALESORG]

Resident [User Authentication];

Re: Section access - All access

Mon, 14 Apr 2014 10:07:59 GMT

To allow all fields use empty fields

* means all listed values in fields

try this :

[User Authentication]:

Load * Inline [

ACCESS, NTNAME, TCTLOW

ADMIN, SERVER-EU\BE11635,

User, SERVER-EU\BE11635, 'S010'

];

Re: Section access - All access

Roop — Mon, 14 Apr 2014 10:10:02 GMT

Hi Kevin,

when you say that the "*" is not recognised .... what happens?

Many thanks

Re: Section access - All access

Mon, 14 Apr 2014 10:18:17 GMT

Thank you very much for the quick response, however, now he created a blank record...

Re: Section access - All access

Mon, 14 Apr 2014 10:19:45 GMT

Rupert,

when I open I don't see any data

But as Bertrand mentions * means all listed values in fields not all fields

Thank you in advance,

Kr,

Kevin

Re: Section access - All access

Mon, 14 Apr 2014 10:30:14 GMT

I think you are getting wrong with section application

Section Access;

[User Authentication]:

Load * Inline [

ACCESS, NTNAME, TCTLOW

ADMIN, SERVER-EU\BE11635, *

User, SERVER-EU\BE11635, 'S010'

];

// -------------------- What filters are enforced per User --------------------

Section Application;

[Branch Authorisation]:

Load

NTNAME,

TCTLOW as [0SALESORG]

Resident [User Authentication];

You shouldn't mention NTNAME.

All you need is

Section Application;

[Branch Authorisation]:

Load * inline [TCTLOW,0SALESORG

S012,S012

];

You can also get the values from 0SALESORG doing a Resident from the table

Section application is the link between users and fields in Qlikview tables.

Re: Section access - All access

SunilChauhan — Mon, 14 Apr 2014 10:32:57 GMT

after section application use

star is *;

hope this helps

Re: Section access - All access

heimo_ernst_wei — Mon, 14 Apr 2014 10:49:32 GMT

I think there is a flaw in your code with:

// -------------------- What filters are enforced per User --------------------

Section Application;

[Branch Authorisation]:

Load

NTNAME,

TCTLOW as [0SALESORG]

Resident [User Authentication];

You shouldn't mention NTNAME.

All you need is

Section Application;

[Branch Authorisation]:

Load * inline [TCTLOW,0SALESORG

S012,S012

];

All restrictions for access have to be in "Section Access"

See a good introduction: Introduction to Section Access

Re: Section access - All access

SunilChauhan — Tue, 15 Apr 2014 03:34:48 GMT

Hi,

can we use two

section application;

in code . as i see there are two section application.

Sunil

Re: Section access - All access

Wed, 16 Apr 2014 06:59:36 GMT

Thank you all for your help in this!!

Greatest community!

Re: Section access - All access

Wed, 16 Apr 2014 07:37:52 GMT

Hi Kevin,

Please mark answers as helpful or correct.

Have a good one.