Section Access Help

[satishkurra]

Hi

Using the below section access script, i assume user ADAM has ADMIN access and he should be able to see all the data as i represented in * and User PETER should be able to see only JCPenney.

Not sure what is happening, when i log with ADAM, i see only JCPenney.

Can someone help me on the same.

In b/w the below things are taken care

I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM, *

USER, PETER, PETER, WALLMART

];

Section Application;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];

[trdandamudi]

Do you have data for Wallmart in your dashboard ?

[satishkurra]

This is just a test data. I don't have data for JCPenney as well

[trdandamudi]

Satish,

Please try the attached and let me know. I used your data so when you login as :

Adam you will see all the data and when you login as Peter you will see only 'Wallmart'

if you want in "Security" tab you can also check "Admin Override Security"

Hope this helps.

[settu_periasamy]

Hi,

Remove '*' and try..

[jagan]

Hi Satish,

Check this links hope it helps you.

Authentication and Authorization in Qlikview

Various levels of security implementation using Section Access

Regards,

Jagan.

[satishkurra]

This is strange. * indicates all data right . any reason to remove *?

[settu_periasamy]

Hi Satish,

See here..  Re: Section Access "Star"

May be you can try like

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, LINK
ADMIN, ADAM, ADAM, *
USER, PETER, PETER, WALLMART
USER, USER,PASSWORD,JCPENNEY
]; 

Section Application;
Provider:
LOAD * Inline [
LINK
JCPENNEY
WALLMART
];

[perumal_41]

use blank as per sethu said

for reference

[avinashelite]

try like this

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM, *

USER, PETER, PETER, WALLMART

];

Section Application;

START is *;

STAR is *;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];