Security hierarchy

[rulohx87]

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

1. A boss can see your own information and that of their subordinates.

I have a qvw example attached . I hope you can help me friends.

Regards

Raúl S.

[adamdavi3s]

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

[rulohx87 · Accepted solution]

Thank you Adam,

I Solved my problem. The attachment content is the solution.

Regards

Raul