Skip to Content
0
Former Member
May 11, 2008 at 03:38 PM

Special query authorization

27 Views

Dear Experts,

I have to solve the following issue in my project. We have a couple of queries w/ a couple of characteristics of course. We need an authorization that lets the user see records with only certain char. values. But there is another query which we have to authorize for the same user for the same characteristic but for diff. char. values. Say, there is a ‘Q1’ and a ‘Q2’ query. Q1 and Q2 includes the same, ‘C’ characteristic. Char. values for C are: ‘C1’, ‘C2’, ..., ‘C10’. User ‘A’ may see in Q1 only records with char. values C1, C2, C3; and the Q2 w/ char. values C5, C6, C7…

How should I do it with the old/new/mixed authorization concept?

Thank you for the answer in advance!

JA