Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

bob_libby_ltb
New Contributor

I need assistance regarding Section Access security

I'm trying to get a handle on how section access security works. In the below scenario I'm trying to give user D access to all of profit center 1000 and only CUSTF in profit center 1010.

What I expect is user D to have access to CUST A, B, C and F in profit center 1000 plus CUSTF in profit center 1010.

What it does is only grant access to user D to CUSTF in 1000 and 1010 plus... CUSTE in 1010? I never associate user D with CUSTE in the script.

Below it the script and attached is the qvw file.

I'm looking for any help or insight as to what's going on.

Thank You,


SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Star is *;

Section Access;

LOAD * Inline [

ACCESS,     USERID,     PASSWORD,   PROFCTR,    CUST

ADMIN,      ADMIN,

USER,       A,          ,           1000

USER,       B,          ,           1010

USER,       C,          ,           *,          CUSTE

USER,       C,          ,           *,          CUSTF

USER,       D,          ,           1000,       *

USER,       D,          ,           1010,       CUSTF

];

SECTION Application;

LOAD * INLINE [

    PROFCTR,      CUST, Sales

    1000,         CUSTA,      100

    1000,         CUSTB,      50

    1000,         CUSTC,      150

    1010,         CUSTD,      200

    1010,         CUSTE,      250

    1000,         CUSTF,      250

    1010,         CUSTF,      50

];

Tags (3)
2 Replies
bob_libby_ltb
New Contributor

I need assistance regarding Section Access security

I'm closing this out, I just received some documentation that should help from QlikView.

Not applicable

Re: I need assistance regarding Section Access security

can you share the documentation that QlikTech sent you?

Community Browser