topic Re: permissions from xls table in QlikView

permissions from xls table

Mon, 18 Feb 2013 09:19:10 GMT

I have module thet get the Permissions for user from SQL Tbl, i used with section access & section Application .

i have to convert my Sql tbl to Xls Tbl (load the tbl from xls) .

when i add the section access & section Application to the loadind from xls it's failed.

but if i commete it it's work fine but i must have this lines.

i copy my code:

from sql- work fine:

ODBC CONNECT TO SQL (XUserId is bbb, XPassword is yyy);

Section Access;
LOAD ACCESS,
      NTNAME,
     DEPT;
SQL SELECT *
FROM bbb.d.QlikviewSec;
Section Application;
LOAD DEPT,
    PATH;
SQL SELECT *
FROM aaa.d.UserDept;

from Xls-not working:

SECTION Access;
LOAD [ACCESS],
NTNAME,
DEPT
FROM
C:\bbb.xls
(biff, embedded labels, table is sheet1);

SECTION Application;
LOAD DEPT,
PATH
FROM

C:\aaa.xls
(biff, embedded labels, table is sheet1)

tnx for healping!

Re: permissions from xls table

alexandros17 — Mon, 18 Feb 2013 09:45:16 GMT

could you provide the xls table so I can try .... I do not see evident mistakes ...

Re: permissions from xls table

Peter_Cammaert — Mon, 18 Feb 2013 09:48:13 GMT

Hi,

you do not mention what exactly is going wrong when you use the XLS code.

What you can do is use the code from Xls-not working, but disable the line "SECTION Access;" for instance add a // in front. Then reload your model without Data Reduction and observe the correctness of the associations via field DEPT. If those are ok, check the NTNAME content and compare with the username you get from QlikView.

BTW, data & fields you use in SA have to be in upper case in order to avoid weird problems.

Good luck,

Peter

Re: permissions from xls table

Mon, 18 Feb 2013 12:21:03 GMT

ACCESS NTNAME DEPT

USER 123456 AAA

USER 223366 BBB

DEPT PATH

AAA C:\q1

BBB C:\q2

Re: permissions from xls table

Mon, 18 Feb 2013 13:10:21 GMT

hi,

tnx for healping.

i did the upper for the values.

it reload the data from the tbl well.

but when i close and open it Again i get the error

"acces denied To this QV document"

if i commete the section acces & application

it's open it well.

what is my worng?

tnx

Re: permissions from xls table

Peter_Cammaert — Mon, 18 Feb 2013 13:18:16 GMT

Well, just guessing now. Do the users 123456 and 223366 really exist in Active Directory or in your Windows Local Users list?

The column NTNAME must contain the names of valid Windows accounts that are authenticated by Windows before they are presented with your QlikView document. If you do not want to use Windows Accounts, use USER & PASSWORD columns to enable QlikView authentication.

Good luck,

Peter

BTW On average, your submission is posted OK the first time, even if the QlikView forum returns an ERROR MESSAGE. After the ERROR, just press Cancel and refresh your page. Your post will be there... Happens all the time with me too.

Re: permissions from xls table

Mon, 18 Feb 2013 14:51:24 GMT

this NTNAME it's not the real data.

in the xls tbl we have NTNAME that is not from my local active directory

but it's a Correct NTNAME.

it must be contain in my local Active Directory?

becuse in real time it's running on the server , in the server we have all the users

but it's not working also.

any idea?

tnx

Re: permissions from xls table

Tue, 19 Feb 2013 09:16:35 GMT

someone know how to see the current user in the module from the active directory?

tnx

Re: permissions from xls table

Peter_Cammaert — Tue, 19 Feb 2013 09:33:43 GMT

In your Xls-version of your model where you have commented out SECTION ACCESS;, put a textbox on a sheet with this content:

=OSUser()

This function returns the Windows account name of the user that has the model open. Usually, the return string consists of two parts, like:

DOMAIN\Accountname

Compare this to the NTNAMEs you have loaded from the XLS.

Good luck,

Peter

Re: permissions from xls table

Wed, 20 Feb 2013 07:04:19 GMT

tnx Peter it's help!

yes, i have this same NTMANE in my XLS sheet (DOMAIN\Accountname)

But the problem stayed.

What should I do???

Re: permissions from xls table

Peter_Cammaert — Tue, 05 Mar 2013 21:56:04 GMT

Still not fixed? I guess something else is wrong. Could you post your QVW, or at least a limited copy (with data) that still isn't working? That would make analysis a lot easier.

Luck,

Peter