topic Re: Section Access Automation in App Development

Section Access Automation

imrasyed — Fri, 16 Nov 2018 15:47:07 GMT

Hi Experts,

I have an excel source for Section Access placed at a location.Now When a user gets Access to a AD group,that particular user needs to be manually added to the Excel source.Can we basically Automate this Process like A User gets access to AD group and that user shd be getting added to Excel?

Really appreciate your help.

Thanks

Syed Imran

Re: Section Access Automation

dplr-rn — Fri, 16 Nov 2018 16:18:54 GMT

Should be possible but thats a non qlikview issue.
What i have implemented is to use a DB table instead of excel (exactly same format) and use a simple custom web app to add new user into the table. Basically this webapp will be operated by admin team and becomes part of the process

Re: Section Access Automation

Miguel_Angel_Baeyens — Fri, 16 Nov 2018 16:32:27 GMT

Adding to what was posted above, you can connect directly to the AD and read users and groups from Qlik script.

AD:
LOAD DISTINCT *;
SQL SELECT
sAMAccountName, name, distinguishedName, userPrincipalName
FROM 'LDAP://DC=subdomain, DC=domain, DC=net' WHERE objectCategory='person';

You have a more refined example in Rob's recipe: http://qlikviewcookbook.com/list-recipes/

Re: Section Access Automation

Vegar — Fri, 16 Nov 2018 21:21:21 GMT

It is possible to assign section access based on AD group. You need to use the section access field name GROUP.

I've pasted in an SA examlple using GROUP below.

section access;
LOAD * inline [
ACCESS, USERID, GROUP, REDUCTION, OMIT
USER, *, ADMIN, *,
USER, *, A, 1,
USER, *, B, 2, NUM
USER, *, C, 3, ALPHA
USER, *, GROUP1, 3,
ADMIN, INTERNAL\SA_SCHEDULER, *, *,
];
section application;

T1:
LOAD
*,
NUM AS REDUCTION;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;

Re: Section Access Automation

imrasyed — Mon, 19 Nov 2018 17:07:37 GMT

Hi MVP,

Thanks for the help

but if I want a particular user to get restricted for some territories(not all) under that group Will I be able to achieve it?

Thanks

Syed Imran

Re: Section Access Automation

imrasyed — Tue, 20 Nov 2018 08:43:53 GMT

Hi I am not able to see the example in the link you provided.Can you send me the correct link or do i need anything else to view the content.