topic Re: Section Access Being Ignored in QlikView

Section Access Being Ignored

Mon, 24 Sep 2012 13:58:33 GMT

Help. I have a major problem. I have a SECTION ACCESS which is not being applied on the server. I cannot deploy this application without this. I have several other applications with similar SECTION ACCESS that are working fine but not this one.

Snippets (cannot provide actual QVW due to proprietary info.):

SECTION ACCESS

LOAD * INLINE [

ACCESS, NTNAME, CLIENT_ID

ADMIN, CRENT\AMACDONALD,

ADMIN, CRENT\JASONP,

ADMIN, CRENT\ROBROBIN,

ADMIN, SCE\SALLEN,

ADMIN, SCE\DNELSON,

ADMIN, SCE\EWHITMORE,

ADMIN, CRENT\QLIKMASTER,

ADMIN, CRENT\QLIKUSER,

USER, "SCE\!SCEALL",

USER, "CRENT\ZCU1", "afc12e33ce244ea03632ee0299000eca",

];

Section Application;

Settings

Document

Server tab - checked: Filter Access Point Document List Based on Section Access

Security tab - checked: reduce data, allow export and Admin override security

Openingn tab - checked: initial data reduction based on Section Access

QEMC

Reduce tab - reduction method / reduce by field value (standard setting)

However, when I log in as userid CRENT\ZCU1 I am still seeing ALL values for CLIENT_ID:

What am I missing!?!?!?!?!?

Sue

Re: Section Access Being Ignored

alexpanjhc — Mon, 24 Sep 2012 14:32:39 GMT

USER, "CRENT\ZCU1", "afc12e33ce244ea03632ee0299000eca",

try to remove the last comma?

Re: Section Access Being Ignored

daveamz — Mon, 24 Sep 2012 14:33:53 GMT

Hello Sue,

Before log in as userid CRENT\ZCU1 close all instances of QV.

David

Re: Section Access Being Ignored

Mon, 24 Sep 2012 14:41:47 GMT

No dice on either of these ideas. 😞

Re: Section Access Being Ignored

alexpanjhc — Mon, 24 Sep 2012 14:57:03 GMT

just out of curiosity, why do you have double quotes on this user but not others? the client id too?

Re: Section Access Being Ignored

Mon, 24 Sep 2012 14:59:54 GMT

I've tried it with/without quotes. No difference. Also tried with/without strict exclusion. Having strict exclusion checked locked me out of the app altogether. Next thing I'm going to try is converting the security VALUE to all caps. I didn't think that was necessary but maybe it is!?!?!?

Re: Section Access Being Ignored

Mon, 24 Sep 2012 15:52:12 GMT

Found!!! The VALUE of the security-related field has to be all upper case, as well as the field name.

So in the data load, added upper(CLIENT_ID) and in the security, converted the key to upper case.

Tada...

Thanks for all the suggestions, folks.