Default user in Section Access

[#1]

Hi,

Is it possible to define a default user in Section access?

What I'm trying to accomplish is that a number of named users (NTNAME) should see a sheet that is hidden for everyone else without having to specify it for every NTNAME. So if a user isn't named in Section access he or she should get a default access level.

Thanks

🙂 Fredrik

[nathanfurby]

Interesting Miguel - makes sense for the COUNTRY field in this example as the Section Access would not know all the values in the Countries table.

But when a * (Star) is used in the ACCESS, USERID, PASSWORD fields I think the functionality must be different. For example, in the real world I am using NTNAME:

Section Access;
Access01:
LOAD * INLINE [
ACCESS, NTNAME, SYSGROUP
ADMIN, qlikview, HIGH
USER, nathan, MEDIUM
USER, *, LOW
];

In this example, anyone can open the document and they will be placed in the SYSGROUP 'LOW'. But this also causes the problem I am experiencing which is e.g. nathan user placed in both 'MEDIUM' and 'LOW' groups.

EDIT: If the * in the above example is replaced with a blank (null) then any user not explicitly listed will be prompted for username/password for which nothing exists and therefore will not gain access to the document.

[Miguel_Angel_Baeyens]

Hi Nathan,

Actually you have to add all users to your section access, because that's the behavior when there are more than one lines matching your user. Think of a different scenario when SYSGROUP (your reduction field) allows more than one possible value and you do want a user to have access to more than one value. There is no way to do that than creating two different lines with the same access, userid and password but different reduction field values, so it's how the section access syntax works.

But further to your question, you can create a section access loading all users from your active directory instad of creating an inline table, reading directly using the OLE DB provider for Microsoft Directory Services and building your section access from

CONNECT TO [Provider=ADsDSOObject;User Id=Domain\YourUser;Password=YourPassword];
Users: LOAD cn;SQL SELECT cn FROM 'LDAP://SERVER.DOMAIN'

Hope that helps

[nathanfurby]

Thanks Miguel. QlikView Support have now confirmed that the 'star' cannot be used as Gordon mentioned, or as I presumed - i.e. to default access to all users not mentioned already in the access list.

[qlikviewforum]

Hi,

The QVW which tries to load the data from LDAP loads only the partial data frequently. We are unable to find the root cause of the issue as the QVW doesn't fails but it loads only the partial data.Can someone please help us to identify the root cause of the issue. It has been happening from quite a long time but we didn't succeed in finding the root cause of the issue. Hope someone can help us for the same.

Regards,

qvforum