Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a set of tables Company / Contact / Order / Employee / +5 More tables.
Each user (employee ) has access to a set of records
Employee | ||
USER | DESIGNATION | NTNAME |
JACK | MANAGER | DMN\JACK |
DAVE | USER | DMN\DAVE |
JOHN | SUPERVISOR | DMN\JOHN |
Company_Access: | |
USER | COMPANY_ID |
JACK | XX1 |
JACK | XX2 |
JACK | XX3 |
JACK | XX4 |
JACK | XX5 |
DAVE | XX1 |
DAVE | XX2 |
JOHN | XX3 |
JOHN | XX4 |
JOHN | XX5 |
Contact_Access: | |
USER | CONTACT_ID |
JACK | YY1 |
JACK | YY2 |
JACK | YY3 |
JACK | YY4 |
JACK | YY5 |
DAVE | YY1 |
DAVE | YY2 |
DAVE | YY3 |
DAVE | YY4 |
JOHN | YY1 |
JOHN | YY2 |
JOHN | YY3 |
JOHN | YY5 |
JOHN | YY100 |
ORDER_Access: | |
USER | ORDER_ID |
JACK | OR1 |
JACK | OR2 |
JACK | OR3 |
JACK | Or4 |
JACK | OR5 |
DAVE | OR1 |
DAVE | OR2 |
JOHN | OR3 |
JOHN | OR4 |
JOHN | OR5 |
SECTION Access;
SecureAccess:
LOAD
NTNAME,
[USER],
EMPLOYEE_ID,
COMPANY_ID,
// CONTACT_ID,
// ORDER_ID
FROM C:\SecureAccess.qvd (qvd) where 1=1;
When I apply this section access – the user gets what he is entitled.
However
Problem 1 –
Problem 2 –
What am I missing / doing wrong
Any help is appreciated.
I think this is a problem with strict exclusion. this option is available in the document properties where u enabled section access.
u filter the access with the employee id , then y would u again use company id.
As u r saying everything is blank, I guess this should be strict exclusion. try unchecking it. then u will see all data if u have restricted it by conflicting fields.
By conflicting fields I mean for eg, u restrict data by employee id and company name. say an employee aaa belong to company xxx. and u have in section access table like
user comany
aaa yyy
this is where the strict exclusion will remove all the data and show a blank. pls use only the field that would be used as a filter in the section access. let this be at the lowest granularity that u would implement section access on.
Pls attach an sample app so that we could assign u more.
Regards,
Sundar