Qlik Community

QlikView Security

Discussion Board for collaboration on QlikView Security.

kikerodriguez10
New Contributor III

Group Users Security without Active Directory.

Hi everyone,

How can I use security in a group of users without AD?

Can I build this security in objects or QVW tabs?


Thanks in advance.

5 Replies
Not applicable

Re: Group Users Security without Active Directory.

Has this been answered elsewhere?

Re: Group Users Security without Active Directory.

This could be done per Section Access whereby if you used NT as authentication you should also use NTNAME within the section access.

- Marcus

Re: Group Users Security without Active Directory.

I'm not entirely sure, but I don't think so.

Actually there are two questions:

  1. Yes you can, using for example local groups or a Custom directory (QV EE only). However, you cannot mix AD/Windows accounts with Custom groups !
  2. Yes, you can using fixed local code/data or external authentication/authorization or any mix of those. See Marcus' answer for all details.
luxlux80
New Contributor II

Re: Group Users Security without Active Directory.

May be possible using Section Access,

Say for example,

Excel has Group list, password and Sheet\Data Access level

Dashboard home sheet should prompt for user group and password, based on the group and password, make the respective sheet\objects visible.

Access to Access point should be done through AD or LDAP.

mgaseron
New Contributor II

Re: Group Users Security without Active Directory.

An option is to have a list of restricted Users managed in a flat file (i.e. Excel) and use association to org hierarchy. Below is an example:

RestrictUsers.png

Then, set document even triggers OnOpen to set OSUser() to the following:

1) a variable - can be used in IF condition or conditional logic for show/hide of Sheet/Object

2) a Select Field - i.e. %OpID and lock if sett to All sheets and objects