topic Re. :Re: Re. :Re: Re. :Access Security and XML File in QlikView

Access Security and XML File

Tue, 27 Jul 2010 15:26:18 GMT

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

Re. :Access Security and XML File

Wed, 28 Jul 2010 08:34:49 GMT

Hello,

Anyone have a suggestion please??

Re. :Access Security and XML File

Thu, 29 Jul 2010 14:24:42 GMT

Hello,

Anybody have a suggestion for this problem please?? Is very Crucial for my report.

Thanks

Re. :Access Security and XML File

suniljain — Thu, 29 Jul 2010 14:48:16 GMT

Please Try This Code.

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

Regards

Sunil.

Re. :Re: Re. :Access Security and XML File

Thu, 29 Jul 2010 14:54:53 GMT

It's not works 😞

Again th same message : Please enter your login 😞

Re. :Access Security and XML File

jonathandienst — Thu, 29 Jul 2010 14:57:59 GMT

Bruno

You may need an asterisk in the blank fields for your NT account in the XML file.

UserId="*" Password="*"

Jonathan

Re. :Re: Re. :Access Security and XML File

Thu, 29 Jul 2010 15:04:54 GMT

It don't change anything 😞

Re. :Re: Re. :Access Security and XML File

Anonymous — Thu, 29 Jul 2010 15:11:19 GMT

When loading Section Access fields, you must always use upper():
upper(UserId) as USERID
upper(Pwassword) as PASSWORD
...

Re. :Re: Re. :Re: Re. :Access Security and XML File

Thu, 29 Jul 2010 15:19:45 GMT

It's Works 🙂 ^^ Thank you very much for your help ^^

Can you explain me why this function is important please? 🙂

Re. :Re: Re. :Re: Re. :Access Security and XML File

Anonymous — Thu, 29 Jul 2010 15:55:55 GMT

Hmm, I can never answer the "why" questions...
This is how it works. Section Access requires field names and field values in upper case. If you use load inline, it will be in upper case as you enter it, but if you load from any data source, you have to convert it using upper() function. Even if you think that the values are in upper case in data source - it may be not reliable.
If you use fields for data reduction in Section Access and Sectio appliaction - the "upper rule" must be used in both places.

Re. :Re: Re. :Re: Re. :Re: Re. :Access Security and XML File

Thu, 29 Jul 2010 16:14:26 GMT

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 ?

Re. :Re: Re. :Re: Re. :Re: Re. :Access Security and XML File

Tue, 03 Aug 2010 10:04:43 GMT

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

Re. :Re: Re. :Re: Re. :Re: Re. :Access Security and XML File

Wed, 04 Aug 2010 09:50:01 GMT

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