Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

dom
Not applicable

Section access wild card

I'm trying to do a simple row level section access. It seems to work for users,  but I am trying to use wildcards for admins, so they can see all accounts. Unfortunately when I use the wildcard it's treated the same as any other text value - so it is looking for the REDUCTION called * and not finding any in the data.

How do let QV know I'm looking ANYTHING not just something called *?

Section Access;

LOAD USERID,
'*'
as PASSWORD,
ACCESS
FROM
Visibility.qvd
(
qvd) WHERE 1=1;

SECTION APPLICATION;

LOAD USERID,
    
REDUCTION
FROM
Visibility.qvd
(
qvd) WHERE 1=1;

Tags (3)
1 Solution

Accepted Solutions
tresesco
Not applicable

Re: Section access wild card

Yes it has to be there in both sections. Only point to note is, the '*' is supposed to be used in section access which would effectively mean all values mentioned in section access REDUCTION field.

8 Replies
tresesco
Not applicable

Re: Section access wild card

Try setting it like:

Star is *;

dom
Not applicable

Re: Section access wild card

Thanks but when I select the field REDUCTION is still only shows *

tresesco
Not applicable

Re: Section access wild card

Your section access should have REDUCTION field too and that is where you should use '*' (not in the application section).

dom
Not applicable

Re: Section access wild card

Really good

I can now see all rows as admin.

> and that is where you should use '*' (not in the application section).

Not sure what you mean about this part of your answer - I have REDUCTION being loaded in both sections, and it seems to work?

Section Access;

LOAD USERID,
'*'
as PASSWORD,

ACCESS,

REDUCTION
FROM
Visibility.qvd
(
qvd) WHERE

1=1;

SECTION APPLICATION;

LOAD USERID,
    
REDUCTION
FROM
Visibility.qvd
(
qvd) WHERE 1=1;


jagan
Not applicable

Re: Section access wild card

Hi,

Check this link, hope it helps you.

Authentication and Authorization in Qlikview


Sample Script:


Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, REDUCTION

    ADMIN, Admin, password, *

    USER, Sales, password1, 1

    USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

   REDUCTION, Dept,

    1, Sales

    2, Marketing];

 

Sales:

LOAD * INLINE [

   Dept, Sales

   Sales, 100

   Sales, 200

   Sales, 4646

   Sales, 755

   Sales, 422

   Sales, 42

   Marketing, 2

   Marketing, 453

   Marketing, 54

   Marketing, 45

];

Regards,

jagan.

tresesco
Not applicable

Re: Section access wild card

Yes it has to be there in both sections. Only point to note is, the '*' is supposed to be used in section access which would effectively mean all values mentioned in section access REDUCTION field.

dom
Not applicable

Re: Section access wild card

Jagan, Has the URL been updated? When I tried to access your link I got:

Unauthorized

Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

jagan
Not applicable

Re: Section access wild card

Hi Daniel,

I attached the sample script in that thread in my previous post.  Please check .

Regards,

Jagan.