topic Re: Section Access "Star" in QlikView

Section Access "Star"

michael_maeuser — Fri, 30 Aug 2013 08:04:34 GMT

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;

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

Re: Section Access "Star"

michael_maeuser — Fri, 30 Aug 2013 08:30:06 GMT

nobody?

Re: Section Access "Star"

tresB — Fri, 30 Aug 2013 08:36:59 GMT

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.

Re: Section Access "Star"

michael_maeuser — Fri, 30 Aug 2013 08:38:46 GMT

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

Re: Section Access "Star"

jjordaan — Fri, 30 Aug 2013 08:47:44 GMT

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

Re: Section Access "Star"

mauro_villa — Fri, 30 Aug 2013 09:06:02 GMT

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

Re: Section Access "Star"

michael_maeuser — Fri, 30 Aug 2013 09:23:29 GMT

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!

Re: Section Access "Star"

jjordaan — Fri, 30 Aug 2013 09:26:51 GMT

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;

Re: Section Access "Star"

Miguel_Angel_Baeyens — Fri, 30 Aug 2013 09:29:17 GMT

Hi Michael,

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

Miguel

Re: Section Access "Star"

jjordaan — Fri, 30 Aug 2013 09:29:31 GMT

I searched for some documents that might help.

Re: Section Access "Star"

michael_maeuser — Fri, 30 Aug 2013 09:31:13 GMT

yes i checked that box

Re: Section Access "Star"

michael_maeuser — Fri, 30 Aug 2013 09:34:51 GMT

i have that documet and i also load everything uppercase in my qvw (sorry forgot it above).

like i wrote, my section access example works now.

the only thing what i don´t understand is, that user with * sees everything (not only listed) if i have my permission data in a database.

e.g. table in db:

User 1, *

User 2, company2

user 1 sees company 1 and 2. so it is another behaviour compared to inline load. that´s what i can´t understand

Re: Section Access "Star"

michael_maeuser — Fri, 30 Aug 2013 09:46:37 GMT

a little late but now i got it why you asked for that sure in my case i shouldn´t activate strict exclusion

Re: Section Access "Star"

jjordaan — Fri, 30 Aug 2013 10:18:35 GMT

Is it possible to share your file?

Re: Section Access "Star"

agigliotti — Thu, 30 Jan 2014 12:22:08 GMT

I'm using EMPTY string (ex '') in section access but with STRICT EXCLUSION checked I can't open the document anymore.

Re: Section Access "Star"

agigliotti — Thu, 30 Jan 2014 12:27:48 GMT

"STAR IS" means all values but NULL is not included !

Re: Section Access "Star"

vivek_kalekar — Tue, 01 Aug 2017 09:44:30 GMT

Yes.exactly...but what needs to be done if i want to see those null values? I am facing a similar problem where 'STAR IS' is used and i can see all the values but not the null !

Re: Section Access "Star"

agigliotti — Tue, 01 Aug 2017 10:05:46 GMT

the only way to see null values is replacing those with a string.