Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a Problem with the Security hierachy. I hope you can help me. I have a table with the users
USERS | ||||
ACCESS | NTNAME | NO_EMPLOYEE | NO_BOSS | JOB |
---|---|---|---|---|
ADMIN | DOMAIN\A00 | 0 | DIRECTOR A | |
USER | DOMAIN\A01 | 1 | 0 | MANAGER A |
USER | DOMAIN\A02 | 2 | 1 | ANALYST |
USER | DOMAIN\A03 | 3 | 1 | DEVELOPER |
USER | DOMAIN\A04 | 4 | 5 | TESTER |
USER | DOMAIN\A05 | 5 | 6 | MANAGER B |
ADMIN | DOMAIN\A06 | 6 | DIRECTOR B |
I have a fact table:
FACT TABLE | |||
NO_EMPLOYEE | NO_COSTUMER | PRODUCT | DATE_SALE |
---|---|---|---|
2 | 123 | PRODUCTO 1 | 07/08/2016 |
3 | 456 | PRODUCTO 2 | 08/08/2016 |
4 | 789 | PRODUCTO 3 | 09/08/2016 |
1 | 678 | PRODUCTO 4 | 10/08/2016 |
Of which I am applying a Section Access to reduce the data:
Section Access;
Security
LOAD ACCESS,
NTNAME,
NO_BOSS
FROM USERS;
Section Application;
If I logging with NO_EMPLOYEE = 1 ( Manager). Just show me employees 2 and 3. But omits the sale of employee 1
My requirement is to get 7,500 users Oracle database and give them access by NTNAME. Without using userid and password
I have a qvw example attached . I hope you can help me friends.
Regards
Raúl S.
Thank you Adam,
I Solved my problem. The attachment content is the solution.
Regards
Raul
Hi Raul,
Do you also wan the subordinates to see their own data as well?
If so then can you not just do this?
USERS:
LOAD ACCESS,
NTNAME, // ADD YOUR USER OF WINDOWS.
NO_EMPLOYEE,
BOSS,
JOB
INLINE [
ACCESS, NTNAME, NO_EMPLOYEE, BOSS, JOB
ADMIN, DOMAIN\A00, 0, , DIRECTOR A
USER, DOMAIN\A01, 1, 0, MANAGER A
USER, DOMAIN\A02, 2, 1, ANALYST
USER, DOMAIN\A03, 3, 1, DEVELOPER
USER, DOMAIN\A04, 4, 5, TESTER
USER, DATA IQ, 5, 6, MANGER B
ADMIN, DOMAIN\A06, 6, , DIRECTOR B
];
concatenate
LOAD ACCESS, NTNAME, NO_EMPLOYEE, NO_EMPLOYEE AS BOSS, JOB
resident USERS;
Otherwise just exclude employees who don't appear in the BOSS column
Thank you Adam,
I Solved my problem. The attachment content is the solution.
Regards
Raul