Section Access "Star"

[michael_maeuser]

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

[michael_maeuser]

nobody?

[tresesco]

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]

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

[jjordaan]

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]

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]

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]

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

Hi Michael,

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

Miguel

[jjordaan]

I searched for some documents that might help.