Section Access with *

[#1]

Hi,

I'm trying to use section access but I don't succeed. I have a simple doc where I use an inline table adding ACCES, NTNAME and DEPARTMENT fields. It is supposed to login automatically recognizing the domain and username and do a reduction by DEPARTMENT.

The thing is that it works when I filter for a specific department, but it doesn't when I try to use the *. It is supposed that using the * and adding other values on the same column (DEPARTMENT in my case) * should represent all listed values. But when I use it it doesn't allow me to open the doc.

I am really stucked on it and I can't find why it is not working as other examples I've found, this one for exampleQlikView Section Access Examples

That's the script I use. Many thanks in advance.

DEP:

load* Inline

[Name, DEPARTMENT

A,ABC

B,XYZ

C,BNH

D,JHK

E,LKJ

F,OLP

];

section_access:

load * inline [

ACCESS, NTNAME, DEPARTMENT

USER, domain\RUBEN.GRAU, *

USER, domain\someone, ABC

];

STAR is *;

SECTION ACCESS;

LOAD

    ACCESS,

    NTNAME,

    DEPARTMENT

RESIDENT section_access;

SECTION APPLICATION;

STAR is;

[Gysbert_Wassenaar · Accepted solution]

* should represent all listed values

That's right and in the below table only ABC is listed:

sectionaccess_tmp:

load * inline [

ACCESS, NTNAME, DEPARTMENT

USER, domain\RUBEN.GRAU, *

USER, domain\someone, ABC

];

So RUBEN.GRAU will only have access to department ABC

[Qrishna]

PSA.

hope that helps.

Use below Ids and pswrds to see their respective data.

ACCESS ,NAME               ,PASSWORD       ,DEPARTMENT

ADMIN   ,RUBEN.GRAU   ,RUBEN.GRAU    , *

USER    ,A                        ,A                         , ABC

USER    ,B                        ,B                         , XYZ

USER   ,SOMEONE          ,SOMEONE           , *

Thanks

[maxgro]

in my test it works (*) but not with section access loaded from resident

DEP:

load* Inline

[Name, DEPARTMENT

A,ABC

B,XYZ

C,BNH

D,JHK

E,LKJ

F,OLP

];

//section_access:

//load * inline [

//ACCESS, NTNAME, DEPARTMENT

//USER, domain\RUBEN.GRAU, *

//USER, domain\someone, ABC

//USER, mydomain\myuser, ABC

//];

SECTION ACCESS;

//STAR is *;

load * inline [

ACCESS, NTNAME, DEPARTMENT

USER, domain\RUBEN.GRAU, *

USER, domain\someone, ABC

USER, domain\someone2, XYZ

USER, mydomain\myuser, *

];

//LOAD

//    ACCESS,

//    NTNAME,

//    DEPARTMENT

//RESIDENT section_access;

SECTION APPLICATION;

//STAR is;

[Qrishna]

i guess domain\RUBEN.GRAU should be included in the 'Name' field.

if we include it, * works fine.

Please see the script in my qvw attached earlier.

[swuehl]

If your user gets access denied, you probably have strict exclusion enabled.

I think what's missing is a

drop table section_access;

at the end of your script. If you don't drop the table, you will get into troubles on opening.