Section access wild card

[Daniel_Moore]

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;

[tresesco]

Try setting it like:

Star is *;

[Daniel_Moore]

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

[tresesco]

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

[Daniel_Moore]

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]

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 · Accepted solution]

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.

[Daniel_Moore]

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]

Hi Daniel,

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

Regards,

Jagan.