Problem Security

[#1]

Hello,

Technical environment:

Windows XP

Qlikview 10 SP3

I have a problem with the management security managed inside excel security (See ).

We want that only User group will be able to see value where Group Name is different to “Confidential” value.

Admin user will be able to see all data.

For this, I created the below script but when users connect it at the application thought Access point then an authentification window is displayed (see Image 1)

                        

            

//Security
section access;

SACCESS:
LOAD DISTINCT
ACCESS,
NTNAME,
upper(ACCESS) AS [Cat Attribute Confidential]
FROM
$(v_ConfigPath)\MDM2_SECURITY.xls
(biff, embedded labels, table is MDM2_SECURITY$);


section application;

Security_Group_Name:
load * inline
[Cat Attribute Confidential,Cat Attribut Group Name
USER,General
USER,Service
USER,Update_Info
ADMIN,General
ADMIN,Service
ADMIN,Update_Info
ADMIN,Confidential
];

Someboby can help me?

Thank you.

Best regards,

Christophe

[Miguel_Angel_Baeyens]

Hi Christophe,

First of all, if you are using NTNAME, you should use the form DOMAIN\USERNAME instead of only the username, as returned by the QlikView function OSUser() (you can use it in a textbox just to see what it returns). The most likely reason for what that dialog appears is that the DOMAIN part is missing, and section access does not recognize the users.

If you want your users to be prompted for user and password, then you need to use USERID and PASSWORD fields instead of NTNAME.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica