Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rulohx87
Contributor III
Contributor III

Security hierarchy

Hello everyone,

I have a Problem with the Security hierachy. I hope you can help me.  I have a table  with the users


USERS
ACCESSNTNAMENO_EMPLOYEENO_BOSSJOB
ADMINDOMAIN\A000DIRECTOR A
USERDOMAIN\A0110

MANAGER A

USERDOMAIN\A0221ANALYST
USERDOMAIN\A0331DEVELOPER
USERDOMAIN\A0445TESTER
USERDOMAIN\A0556MANAGER B
ADMINDOMAIN\A066DIRECTOR B

I have a fact table:

FACT TABLE
NO_EMPLOYEENO_COSTUMERPRODUCTDATE_SALE
2123PRODUCTO 107/08/2016
3456PRODUCTO 208/08/2016
4789PRODUCTO 309/08/2016
1678PRODUCTO 410/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.

1 Solution

Accepted Solutions
rulohx87
Contributor III
Contributor III
Author

Thank you Adam,

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

Regards

Raul

View solution in original post

2 Replies
adamdavi3s
Master
Master

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
Contributor III
Contributor III
Author

Thank you Adam,

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

Regards

Raul

View solution in original post