Section Access - * showing in filter

[#1]

Hi all,

after some initial problems I finally managed to get Section Access to work, or at least I thought so. I have no problem limiting access to certain data, for certain users, but my problem relates to the user that should have access to everything. As I've understood you should use a * as a wildcard indicator but I can't get it to work! This is my code:

Section Access;
LOAD * INLINE [
 ACCESS, NTNAME
 ADMIN, USER1
 USER, USER2
];

Section Application;
Data:
LOAD * INLINE [
 NTNAME, <field>
 EPM-EMA\USER1, *
 EPM-EMA\USER2, 5080
];

Everything loads ok but if I open the QVW file in the plugin, USER2 can only see the the data that he should and the filter for <field> onloy shows 5080 but USER1 only see a * in the filter, instead of all the data...

In QlikView Developer I can see all data in the filter, with a * on the last row...

Any ideas?

[#2 · Accepted solution]

Have you defined star to QV?

Add this line (before Section Access):

star is *;

Regards,

Gordon

[#3]

Thanks Gordon, that did the trick!

While on the "Section Access" subject, could I please ask you another question? As you can see I've listed some users as ADMIN and some users as USER in my Section Access (my user list is of course much longer in real life, but I just included two users in my example).

Does ADMIN and USER have any functionality for Section Access or is it just a Meta-data for the developer to keep track of the different kind of users?

[#4]

A user with ADMIN access can get at the security tab in document properties / user preferences etc. so it is important that it is only given to those users who really are administrators.

Have you got the 'Data Protection and Security' manual - it gives some good detail

Regards,

Gordon

[amit_shetty78]

Hi Gordon, Can you pls point me to the direction where can I find the 'Data Protection and Security' manual?

Thanks,

Amit.

[#6]

I cannot find it on the website and its not under 'downloads'. Here is the version I have - a little old but I am sure still 'up-to-date'

Regards,

Gordon

[#7]

Thanks again Gordon!