topic Re: Section Access - on Access Point in QlikView

Section Access - on Access Point

vinieme12 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I have a problem where users defined as Admin are able to view the document on Access point but everyone else is being prompted for username and password!! I do not want other users to be prompted for userid and password.

I have the below Section Access Script so that only 4 of the users have Admin access to the document and the User can see only SHEET1.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NTNAME

ADMIN, *, *, dom\user1

ADMIN, *, *, dom\user2

ADMIN, *, *, dom\user3

ADMIN, *, *, dom\user4

USER,,,*

];

Section Application;

ACCESSLEVEL:

LOAD * INLINE [

ACCESS , SHEET1,SHEET2,SHEET3

ADMIN,1,1,1

USER,1,0,0

];

Thanks

Re: Section Access - on Access Point

agni_gold — Wed, 31 Aug 2016 04:54:35 GMT

Hi ,

Please also check this setting at QMC

Re: Section Access - on Access Point

vinieme12 — Wed, 31 Aug 2016 05:05:47 GMT

Hi Agnivesh,

Thanks for your response, I will get this checked with the IT team.

Thanks

Vineeth

Re: Section Access - on Access Point

vinieme12 — Fri, 02 Sep 2016 09:51:34 GMT

Hi,

Checked with IT and these are what the options are set to but still only people defined as Admin are able to access

Does the below not work on AccessPoint??

USER,,,*

Thanks

Vineeth

Re: Section Access - on Access Point

agomes1971 — Fri, 02 Sep 2016 10:00:54 GMT

Hi,

please see this

ntname in the section of access

Section Access NTNAME

How to use Section Access with NT ID

HTH

André Gomes

Re: Section Access - on Access Point

stigchel — Fri, 02 Sep 2016 10:11:04 GMT

The * in the section access table actually means all listed values in the section access table, in this case user1-user4., no other values.

Further the ADMIN and USER properties only make a difference in an offline distribution model (protecting the document properties security settings)

Re: Section Access - on Access Point

vinieme12 — Fri, 02 Sep 2016 10:26:11 GMT

Ah, I will need to define all users then..Thanks stigchel

One observation I would like to share is that show/hide sheets in my section access based on User ACCESS did work .Admins are able to see all sheets whereas Users only Sheet1