Access Security and XML File

[#1]

Hello,

I have a problem with the Session Access in Qlikview :

I have many reports (8 in total) and each of them have User Access different.

I want to use a XML file to write their rights.

<?xml version="1.0" encoding="UTF-8"?>
<Security>
 <Users App="Payment Report">
 <User Access="ADMIN" UserId="" Password="" NTName="ADMIN03\Qlikview Administrators "/>
 <User Access="ADMIN" NTName="*" UserId="ADMIN" Password="ADMIN" />
 </Users>
</Security>

And I use in my QVW script:

Section Access;

LOAD Access as ACCESS,
 UserId as USERID,
 Password as PASSWORD,
 NTName as NTNAME
FROM [$(pathSecu)QV_Security.xml] (XmlSimple, Table is [Security/Users/User]);

Section Application;

My problem is that my NT Account is not recognised by Qlikview when a Open my file after the reload.

I don't understand why but when I used the Access Users Helper in the Edit Script and i add manually my Account like this:

Section Access;
LOAD * INLINE [
 ACCESS, USERID, PASSWORD, NTNAME
 ADMIN, , , ADMIN03\Qlikview Administrators
];
Section Application;

I succeed to open my file.

Can you help me to understand the difference please and resolve my problem ?[:'(]

Kind Regards,

Bruno

[#2]

Thank you very much 🙂 ^^

It's works perfectly now.

I can use now a Bash Script to load my QVW ^^

I use the command QV.exe /nodata /r Name.QVW

. They are a solution to Reduced the data and saved the file with any data in Command Line please?

Because the option Nodata open the file with any data but He don't save and close ?

[#3]

Hello,

I have a problem with the Security acces for Users in TABS :

I use this script :

SecurityUsers:
LOAD App,
 %Key_Users_335982C89FAF2002 // Key for this table: Security/Users
FROM [$(pathSecu)QV_Security.xml] (XmlSimple, Table is [Security/Users]);


INNER JOIN (SecurityUsers)
LOAD Access as [ACCESS],
 NTName as [NTNAME],
 UserId as [USERID],
 Password as [PASSWORD],
 UserGroup as [USERGROUP],
 %Key_Users_335982C89FAF2002 // Key to parent table: Security/Users
FROM [$(pathSecu)QV_Security.xml] (XmlSimple, Table is [Security/Users/User]);

Groups:
LOAD App,
 %Key_Groups_54382BD20F57B5D1 // Key for this table: Security/Groups
FROM $(pathSecu)QV_Security.xml] (XmlSimple, Table is [Security/Groups]);

INNER JOIN (Groups)
LOAD Name,
 Business,
 Site,
 Sport,
 %Key_Groups_54382BD20F57B5D1 // Key to parent table: Security/Groups
FROM [$(pathSecu)QV_Security.xml] (XmlSimple, Table is [Security/Groups/Group]);

section access;

replace LOAD UPPER([ACCESS]),
 UPPER([NTNAME]),
 UPPER([USERID]),
 UPPER([PASSWORD]),
 UPPER([USERGROUP]) as [GROUP]
RESIDENT SecurityUsers
WHERE App = 'Trading Desk';

section application;
star is *;

DROP TABLE SecurityUsers;

USERGROUP_SHEETS:
replace LOAD UPPER([Name]) as [GROUP] ,
 Sport as "STATS_BETS.sport_trad"
RESIDENT Groups
WHERE App = 'Trading Desk';

For the reload in the QVW script.

My XML file is :

<Users App="Trading Desk">
 <User Access="ADMIN" NTName="qlikview" UserId="*" Password="*" UserGroup="ADMIN" />
 <User Access="ADMIN" NTName="*" UserId="ADMIN" Password="ADMIN" UserGroup="ADMIN" />
 <User Access="ADMIN" NTName="MAL-BI01\QlikView Administrators" UserId="*" Password="*" UserGroup="ADMIN" />
 <User Access="ADMIN" NTName="ADMIN03\QlikView Administrators" UserId="*" Password="*" UserGroup="ADMIN" />
 <User Access="ADMIN" NTName="bmartinsledo" UserId="*" Password="*" UserGroup="ADMIN" />
 <User Access="User" NTName="pviswanath" UserId="*" Password="*" UserGroup="ADMIN" />
 <User Access="User" NTName="cdolain" UserId="*" Password="*" UserGroup="TD" />
 </Users>
 <Groups App="Trading Desk">
 <Group Name="ADMIN" Business="*" Site="*" Sport="*" />
 <Group Name="TD" Business="*" Site="*" Sport="*"/>
 <Group Name="TURF" Business="Betclick" Site="*" Sport="Horse Racing" />
 <Group Name="TURF" Business="Betclick" Site="*" Sport="Horse Racing Int." />
 </Groups>

But the users in ACCESS User with a UserGroup TD or Turf don't have access are the sheets.

I want that users of UserGroup TD have access to ALL SPORT in STATS_BETS.sport_trad and

the users of USerGroup TURF have only access to the Sport Horse Racing and Horse Racing Int.

Please can you help me to understand why it's not works??

Thanks ^^

King regards,

Bruno

[#4]

Please anyone have an idea ?

The security of the open QVW is OK but it left the security of Sheets is very different I don't understand why this not work