topic Re: Security hierarchy in QlikView

Security hierarchy

rulohx87 — Wed, 10 Aug 2016 15:46:33 GMT

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:

NO_EMPLOYEE	NO_COSTUMER	PRODUCT	DATE_SALE
FACT TABLE
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

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.

Re: Security hierarchy

adamdavi3s — Thu, 11 Aug 2016 07:20:11 GMT

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

Re: Security hierarchy

rulohx87 — Thu, 11 Aug 2016 22:03:20 GMT

Thank you Adam,

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

Regards

Raul