Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_maeuser
Partner Ambassador
Partner Ambassador

Section Access "Star"

Hi,

is it possible that section access works differently, depending if I load the data inline or from a sql database?

Example 1:

Section Access;

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, LINKFIELD

    ADMIN, DOMAIN\User1, *

    ADMIN, DOMAIN\User1, 1

    ADMIN, DOMAIN\User2, *

    USER, DOMAIN\User3, 2

];

Section Application;

STAR is *;

SecLink:

LOAD * Inline [

LINKFIELD, Company

1, company1

2,company2

];

This example works fine now, but I thought that the second line from the section access table is not necessary since User1 has a star. But without that line it doesn´t work anymore. I must have all each value loaded at least once in the section table, otherwise even the useres with * don´t see all companies.  What I think is strange, is that I also have another example where I load the section access table from a sql database. In this case it´s enough if the database table looks like that:

ACCESS, NTNAME, LINKFIELD

    ADMIN, DOMAIN\User1, *

   ADMIN, DOMAIN\User2, *

    USER, DOMAIN\User3, 2

User 1 and User 2 see both companies. If I change my inline load from the first table, so that it looks like that, user1 and user2 will also only see company 2

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Michael,

Did you check the "Strict Exclusion" box in the Settings menu, Document Properties, Open?

Miguel

View solution in original post

17 Replies
michael_maeuser
Partner Ambassador
Partner Ambassador
Author

nobody?

tresesco
MVP
MVP

If you want to mean ALL values even if all of them are not mentioned in the section access part, use balnk (nothing) rather than '*' .

like:  ADMIN, DOMAIN\User1,

Hope that helps.

michael_maeuser
Partner Ambassador
Partner Ambassador
Author

i also tried that, problem is that access point needs a star. so this way only works in full client

jjordaan
Partner - Specialist
Partner - Specialist

Star within Section Access means all listed.

In my case I use # (or a different sign) for identifying that a certain user may see everything, also the values that are not listed for example Company 3 and 4

See the attached example

User admin

PW admin

mauro_villa
Partner - Contributor II
Partner - Contributor II

As Jeroen said, star in section access doesn't mean that the user can see all the values on QV but only the values listed in section access (for him or for the others).

So if no one can see le value "1" unfortunately you have to specify the value "1" for the User 1.

Bye,

Mauro

michael_maeuser
Partner Ambassador
Partner Ambassador
Author

ok that helps a lot, but I still don´t get it why it works if I load the permission data from a database.

Thanks!

jjordaan
Partner - Specialist
Partner - Specialist

The fields that are linked (from section access to company) needs to be Upper Case.

You can test it be committing the Fields

//Section Access;

//Star is *;

Permisiontable:

LOAD * INLINE

[

    ACCESS, USERID, PASSWORD, ACTORS

    ADMIN, ADMIN, ADMIN, #

    ADMIN, MANAGER, MANAGER, *

    USER, USER, USER, ALEC BALDWIN

    USER, USER1, USER1, ALAN HALE

];

//Section Application;

Miguel_Angel_Baeyens

Hi Michael,

Did you check the "Strict Exclusion" box in the Settings menu, Document Properties, Open?

Miguel

jjordaan
Partner - Specialist
Partner - Specialist

I searched for some documents that might help.