Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
trying following simple section access script in Qlik Sense gives error access denied ? is there issues with script ? or Qlik Sense is not still allowing for section access
Section Access;
LOAD
UPPER("ACCESS") as ACCESS,
UPPER("USERID") as USERID,
UPPER(LCO) as LCO
INLINE [
ACCESS, USERID, LCO
ADMIN, AA\ADMIN1, *
USER, AA\USER01, B
USER, AA\USER01, C
USER, AA\USER01, D
USER, AA\USER01, E
USER, AA\USER01, F
USER, AA\USER01, G
USER, AA\USER01, H
USER, AA\USER01, I
USER, AA\USER01, A
USER, AA\USER01, J
USER, AA\USER01, K
USER, AA\USER01, L
USER, AA\USER01, M
ADMIN, AA\ADMIN2, *
ADMIN, INTERNAL\sa_scheduler, *
];
SECTION APPLICATION;
LOAD
UPPER(LCO) as LCO,
Score
INLINE [
LCO, Score
A, 1
B, 2
C, 3
D, 4
E, 5
F, 6
G, 7
H, 8
I, 9
J, 10
K, 11
L, 12
M, 13
];
I suggest two things for troubleshooting.
which user are you trying to connect with?
Is AA the actual User Directory value that appears in your QMC when you look at your users?
Are these users actually defined in the QMC?
As Andrea asked. Which user were you testing with? That might be helpful.
I have tested my user id as well bpcldev\vikas.onkar.mahajan with admin option but it shows access denied message in qvf.
Vikas
Hi Vikas
Try using NTNAME instead of USERID. Userid reflects not to the username supplied by ntlm.
Cheers
Andy
I suggest two things for troubleshooting.
Thanks Working as per your steps
Vikas
You can now test our new Product SAM that will fully automate Section Access Generation product.
It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.
A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .
Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, a time saving for simple cases.
More details on our website or contact me at jp.golay@ebiexperts.com