Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Section Access Testing in Qlik Sense Server ( Dec 2017 release)

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

];

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
1 Solution

Accepted Solutions
ToniKautto
Employee
Employee

I suggest two things for troubleshooting.

  1. Load section access table as a normal data table, and validate that it is properly defined and links to your data model as expected.
    • Comment out SECTION ACCESS line in your script
    • Comment out SECTION APPLICATION line in your script
    • Reload to make section access table a visible entity in your data model

  2. Validate your userid
    • Validate in QMC what userid your user is known by
    • Visualize userid by using OSUser() in a sheet object
    • Update section access as required to match your userid


View solution in original post

7 Replies
agigliotti
Partner - Champion
Partner - Champion

which user are you trying to connect with?

rittermd
Master
Master

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.

vikasmahajan
Author

I have tested  my user id as well  bpcldev\vikas.onkar.mahajan  with admin option but it shows access denied message in qvf.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
andrpfist
Partner - Contributor
Partner - Contributor

Hi Vikas

Try using NTNAME instead of USERID. Userid reflects not to the username supplied by ntlm.

Cheers

Andy

ToniKautto
Employee
Employee

I suggest two things for troubleshooting.

  1. Load section access table as a normal data table, and validate that it is properly defined and links to your data model as expected.
    • Comment out SECTION ACCESS line in your script
    • Comment out SECTION APPLICATION line in your script
    • Reload to make section access table a visible entity in your data model

  2. Validate your userid
    • Validate in QMC what userid your user is known by
    • Visualize userid by using OSUser() in a sheet object
    • Update section access as required to match your userid


vikasmahajan
Author

Thanks Working as per your steps

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
jp_golay
Partner - Creator II
Partner - Creator II

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

jp_golay_0-1639987982182.png

 

 

 

 

ebiexperts CTO
With WIP, Control everything!
Qlik Sense, QlikView and NPrinting Source control, Versioning and Deployment, Agile Lifecycle Management