Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Section Access with *

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;

1 Solution

Accepted Solutions

Re: Section Access with *

* 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


talk is cheap, supply exceeds demand
5 Replies

Re: Section Access with *

* 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


talk is cheap, supply exceeds demand
krishna_2644
Valued Contributor III

Re: Section Access with *

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

MVP
MVP

Re: Section Access with *

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;

krishna_2644
Valued Contributor III

Re: Section Access with *

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.

MVP
MVP

Re: Section Access with *

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.

Community Browser