Section Access: Access denied after setting document Thumbnail

[#1]

Hi,

I have a very peculiar problem with my section access.

I have had my section access running fine for the last 2 weeks - Yesterday i changed the thumbnail of my document and now if i try and login as a user that has strict exlusion i get the message 'Access Is Denied'

To prove a point - i made a backup of my document before changing yesterday - all my user logins work perfectly as they should with this back.

- if i open my backup document, change the document Thumbnail ( im changing this in settings > opening ) and then save.

If i go back into the document i have just saved and try logging in as any user with strict exlusion (i.e can only see sales for a certain region) i get the message ' ACCESS IS DENIED'

Yet i can still open the original back copy with any user (before saving a new thumbnail)

Is this a bug for Qlikview or has the document thumbnail got something to do with the section access.

Tearing my hair out here!!! coulld someone please help!!  

Thanks in advance

Dan

[Miguel_Angel_Baeyens]

Dan,

Try to change the thumbnail to a sheet where there is no restricted data (say a landing sheet with only a text object, just in case). Does that keep hapenning?

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

Hi Miguel

Thanks for the reply - i created a new sheet and created a new text object - set thumbnail to open on this new sheet - still 'ACCESS DENIED'

I even set the thumbnail to be a simple image on my c drive - still 'ACCESS DENIED'

Any more ideas?

Kind Regards

Dan

[Miguel_Angel_Baeyens]

Dan,

I'm trying that using QV10 SR3 and that doesn't happen. I did a simple document with section access and strict exclusion enabled. Change the thumbnail to an image, it opens ok after asking for credentials. Change the thumbnail to None and keeps working. I'm accessing with both admin and user accounts in section access.

Am I missing something? What version of QlikView are you using?

With the section access you are reducing data. Is there any chance the user you logged in as has reduced data so any other user has no records available to log in? For example, say you have USER1 and this user is reduced to see only records in reduction field GROUP1. If you save and then log in as USER2 who is reduced to only see GROUP2 you are likely to get access denied, since USER1 left no records related to GROUP2, and so the USER2 is not granted access.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#5]

Hi Miguel

Im using the same verison (QV10 SR3) - i;ve added below a copy of my script!

Security:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SITE

    Admin, Admin, Admin, ALL

    User, User1, password1, ALL

    User, User2, Finance2, DUNG

   User, User3, Finance2, SAWL

Section Application;

star is *;

load * inline

[SITE,DivisionCode

ALL,*

DUNG,DMG

SAWL,RCF ] ;

[#6]

Hi,

I just noticed ]; is missing after the first table load statement. Please do the correction adn let me know the feedback.

Also for admin to get access to all data you need not mention All, just leave blank in the first table load.

Cheers.

[Miguel_Angel_Baeyens]

Dan,

Using the following script (just a bit of cleanup of yours) works fine in my side

SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SITE
ADMIN, ADMIN, ADMIN, ALL
USER, USER1, PASSWORD1, ALL
USER, USER2, FINANCE2, DUNG
USER, USER3, FINANCE2, SAWL
];
SECTION APPLICATION;
// ALL has all possible values, otherwise (very important) ADMIN won't be granted access in Server 
Data:
LOAD * INLINE [
SITE, DivisionCode
ALL, DMG
ALL, RCF
DUNG, DMG
SAWL, RCF 
];

I'm changing between all possible options for thumbnails (none, default, image) in the document properties and all of them work fine in server and desktop.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#8]

Hi Dan,

One thing I have found with Section Access is that when you make a change to a document and hit save you are prompted to save as and then have to overwrite the original document. I am not sure if this is what is happening to you but in order for Section Access to continue working when this happens you need to reload the application again and save.

Kind Regards,

Footsie