Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
robert_young_hc
Contributor
Contributor

Select Access with reduction not working for Admin

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;

0 Replies