Select Access with reduction not working for Admin

robert_young_hc — Thu, 21 Feb 2013 20:17:07 GMT

I am having a problem getting the Select Access to work properly. That being said it is but will not load for either myself, or as the QV service account when using the enterprise console to perform a load, load fails. On the presentation server I get asked for the application to load it askes for my login and password. I am set as admin and can open it under the developer. Below is the code I use to secure the application. Note that the reduction is working on the server it is just the admin's that can not get access.

SET ROOTDSE = 'DC=HCM,DC=AM,DC=MDS,DC=HONDA,DC=COM';

CONNECT TO [PROVIDER=ADSDSOOBJECT;ENCRYPT PASSWORD=FALSE;INTEGRATED SECURITY=SSPI;LOCATION=*******;MODE=READ;BIND FLAGS=0;ADSI FLAG=-2147483648];

LET ARG=CHR(01); // SET SEARCH START NAME TO A VERY LOW VALUE
DO

USERTABLE:
LOAD
'HCM\' & NAME AS NTNAME,
LEFT(DEPARTMENT,2) AS HCM_DEPT
;
SQL SELECT
NAME, DEPARTMENT // FIELDS TO SELECT
FROM 'LDAP://OU=USERS,OU=****,DC=****,DC=****,DC=****,DC=****,DC=COM';

SECURITY:
LEFT KEEP (GroupLeaders)
LOAD
NTNAME,
HCM_DEPT
RESIDENT USERTABLE;

DROP TABLE USERTABLE;

SECTION ACCESS;
STAR IS *;

LOAD
'USER' AS [ACCESS]
,NTNAME AS NTNAME
,HCM_DEPT
RESIDENT SECURITY;

LOAD * INLINE [
    ACCESS, NTNAME, HCM_DEPT
    ADMIN, HCM\IS06109,*
    ADMIN, HCM\VEC16069,*
ADMIN, HCM\hcm_svc_qlikviewv9,*
ADMIN, HCM\ISTMP03,*
];

LOAD
ACCESS,
NTNAME,
REDUCTION
;
SELECT
ACCESS,
NTNAME,
REDUCTION
FROM
QVDB.DBO.QLIKVIEWACCESS;

SECTION APPLICATION;

topic Select Access with reduction not working for Admin in QlikView

Select Access with reduction not working for Admin