Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yes i checked that box
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
a little late but now i got it why you asked for that sure in my case i shouldn´t activate strict exclusion
Is it possible to share your file?
I'm using EMPTY string (ex '') in section access but with STRICT EXCLUSION checked I can't open the document anymore.
"STAR IS" means all values but NULL is not included !
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 !
the only way to see null values is replacing those with a string.