Section Access and several fields

[#1]

Hello!

I have the following problem with section access.

I have 6 users:

User1

User2

User3

User4

User5

User6

User1 must see field name SALESMAN and Field value "user1"

User2 must see field name SALESMAN and Field value "user2"

User3 must see field name MANAGER and Field value "user3"

User1 must see field name MANAGER and Field value "user4"

User1 must see field name EMPLOYEE and Field value "user5"

User1 must see field name EMPLOYEE and Field value "user6"

Must i do 3 "section access" in my QV document for fieldnames SALESMAN, MANAGER , EMPLOYEE ?

Can any help me please?

[hic]

You should not do 3 Section Access.

But what you should do depends of what the users should see. Should User1 see the intersection between SALESMAN='user1' and MANAGER='user1' and EMPLOYEE='user1'? Or should he see the union between the three?

My guess is that it is the union. If so, then it is a complex problem for which you need Generic Keys. Start by reading the blog post about complex authorization. Then the Technical Brief about Generic Keys.

HIC

[#3]

I'm sorry, it was mistake.

User1 must see field name SALESMAN and Field value "user1"

User2 must see field name SALESMAN and Field value "user2"

User3 must see field name MANAGER and Field value "user3"

User4 must see field name MANAGER and Field value "user4"

User5 must see field name EMPLOYEE and Field value "user5"

User6 must see field name EMPLOYEE and Field value "user6"

[hic · Accepted solution]

So, you want User1 to have a restriction in SALESMAN but no restriction in MANAGER or EMPLOYEE? I.e. an authorization table like the one below?

Then you should definitely read the linked posts in my previous response.

HIC

[#5]

Thank you, i understood!