Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
New Contributor III

section access no Admin privileges

I need to restrict USER access to the User’s data.
Issue is when I reload the QVW I see all of the data. When I close the QVW and re-open it I see no data; as an ADMIN I should see everything.in the Data Model script:
Permissions:
NoConcatenate
LOAD Consultant,
[Permissions Group],
[USER ID],
upper([USER ID]) as USERNAME
FROM
[D:\QVSource\RIS\UAT\Datasources\QVD\Permissions.qvd]
(qvd);

Dashboard Properties Opening tab:
Checked “Initial Data Reduction Based on Section Access
In the Dashboard script:
Section Access;
SA_Table:
Load
upper(ACCESS) as ACCESS,
upper(NTNAME) as NTNAME,
upper(USERNAME) as USERNAME
Resident AccessII;

Section Application;
AT_SECURITY:
Load
'BBT-USER\' & upper([USER ID]) as NTNAME,
upper([USER ID]) as USERNAME
FROM $(vQVDPath)\Permissions.qvd(QVD)
WHERE 1=1;

Tags (1)
Labels (1)
1 Reply
Highlighted
Digital Support
Digital Support

Re: section access no Admin privileges

Jim, couple of key things to understand, when you run a reload, you are reloading all of the tables including Section Access, so you will have full access to everything following the reload until you save and reopen, this is working as expected.

Another key concept to understand, ADMIN access level is only enabled when opening the application in the Desktop Client, when you open things via QlikView Server, you are ALWAYS a USER regardless of whether you have ADMIN access in the Section Access table or not...

The next thing to understand is when using dynamic data reduction and reduction fields in the section access table, if your user ends up having no records in the reduction field, you will be locked out of the application on the QlikView Server, and you may in Desktop as well if Admin Override Security setting is not checked in the Document Properties Security tab settings as well I believe.  

Here are a bunch of links I hope you will find useful that should do a better job of explaining things than I can do here:

Help link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Note on this one, there are three other Design Blog links at the bottom of that post dealing with dynamic reduction etc., so be sure to check those out as well.  If you have further questions after looking things over, shout back.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.