Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all below is my coding of qliksense which is not working fine for me, i have given access to me(X123456) as admin for all account as *, after runing and seeing the app it is not showing the app and getting as an access denied.
pls help me on this
SECURITY_USER_TABLE:
LOAD
FIRSTNAME,
"ACCESS" as ACCESS,
'XO2\'& "USERID" as USERID,
XLCOMPANYGUID
FROM [lib://vPrepQVDPath (XX011_X123456)/TRANSFORMATION_SECURITY.qvd]
(qvd);
Concatenate
LOAD * INLINE [
FIRSTNAME,ACCESS,USERID,XLCOMPANYGUID
QASERVICEACCOUNT1,ADMIN,X02\SADD02QlikSenseQA,
QASERVICEACCOUNT2,ADMIN,INTERNAL\X02QlikSenseQA,
Manoranjan,ADMIN,RO2\X123456,*
Vignesh,ADMIN,RO2\X122756,*
Karan,ADMIN,RO2\X123410,*
];
SECTION ACCESS;
LOAD
UPPER(USERID) AS USERID,
UPPER(ACCESS) AS ACCESS,
UPPER(XLCOMPANYGUID) as XLCOMPANYGUID
Resident SECURITY_USER_TABLE;
SECTION APPLICATION;
Drop Table SECURITY_USER_TABLE;
You posted in "QlikView App Development"...
Posting a problem with Section Access in Qlik Sense in a QlikView forum is a bit weird.
Consider moving your question to an appropriate Qlik Sense forum by following the steps listed here: QlikCommunity Tip: How to move your discussion thread
Hi Manoranjan,
Section access is not possible in QS Desktop version.
Sections access is possible in QS Server, STREAMS is a concept used in QS Server.
You need to create streams and give access to user of that streams.
Regards,
Rajan
yes i m doing in the QS server only
See if this can help u..
Sections in the script ‒ Qlik Sense
You can achieve what you want by Streams also. i have not worked on Section Access
Go through this https://community.qlik.com/message/797160?&_ga=2.226608792.442944211.1506512576-206219707.1505195290...
Regards,
Rajan Kasbe
try below code:
SECTION ACCESS;
LOAD
UPPER(USERID) AS USERID,
UPPER(ACCESS) AS ACCESS,
UPPER(XLCOMPANYGUID) as XLCOMPANYGUID;
LOAD
FIRSTNAME,
"ACCESS" as ACCESS,
'XO2\'& "USERID" as USERID,
XLCOMPANYGUID
FROM [lib://vPrepQVDPath (XX011_X123456)/TRANSFORMATION_SECURITY.qvd]
(qvd);
Concatenate
LOAD * INLINE [
FIRSTNAME,ACCESS,USERID,XLCOMPANYGUID
QASERVICEACCOUNT1,ADMIN,X02\SADD02QLIKSENSEQA,
QASERVICEACCOUNT2,ADMIN,INTERNAL\X02QLIKSENSEQA,
MANORANJAN,ADMIN,RO2\X123456,*
VIGNESH,ADMIN,RO2\X122756,*
KARAN,ADMIN,RO2\X123410,*
];
SECTION APPLICATION;
...
...
Hi manoranjan
try this
STAR is *;
SECTION ACCESS;
LOAD
UPPER(USERID) AS USERID,
UPPER(ACCESS) AS ACCESS,
UPPER(XLCOMPANYGUID) as XLCOMPANYGUID;
LOAD
FIRSTNAME,
"ACCESS" as ACCESS,
'XO2\'& "USERID" as USERID,
XLCOMPANYGUID
FROM [lib://vPrepQVDPath (XX011_X123456)/TRANSFORMATION_SECURITY.qvd]
(qvd);
Concatenate
LOAD * INLINE [
FIRSTNAME,ACCESS,USERID,XLCOMPANYGUID
QASERVICEACCOUNT1,ADMIN,X02\SADD02QLIKSENSEQA,
QASERVICEACCOUNT2,ADMIN,INTERNAL\X02QLIKSENSEQA,
MANORANJAN,ADMIN,RO2\X123456,*
VIGNESH,ADMIN,RO2\X122756,*
KARAN,ADMIN,RO2\X123410,*
];
SECTION APPLICATION;
Please make sure Sevice account has ADMIN ACCESS and typed correctly because it is going to reload the data.
regards
Pradosh