permissions from xls table

[#1]

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!

[alexandros17]

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

[Peter_Cammaert]

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

[#4]

ACCESS  NTNAME         DEPT

USER       123456           AAA

USER       223366           BBB

DEPT    PATH

AAA     C:\q1

BBB      C:\q2

[#5]

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

[Peter_Cammaert]

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.

[#7]

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

[#8]

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

tnx

[Peter_Cammaert]

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

[#10]

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???