Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
vinieme12
Champion II
Champion II

Section Access - on Access Point

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

V

1 Solution

Accepted Solutions
agomes1971
Specialist II
Specialist II

6 Replies
agni_gold
Specialist III
Specialist III

Hi ,

Please also check this setting at QMC

A.jpg

vinieme12
Champion II
Champion II

Hi Agnivesh,

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

Thanks

Vineeth

vinieme12
Champion II
Champion II

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

agomes1971
Specialist II
Specialist II

stigchel
Partner
Partner

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)

vinieme12
Champion II
Champion II

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