Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
oliverrichter
Contributor III
Contributor III

Section Access in Acces Point without Publisher

Hi,

we use the QlikView Server without the publisher (we're a small company - only 6 QV Licenses) and want to restrict the access of some parts of our QlikView documents. I've heard about "Section Access".

I read here in this community that there are some issues when it comes to using section access in an access point and now I can confirm the problems.

I would like to use section access with NTNAME, ACCESS like

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME

Admin, User1

Admin, User2

User, User3

User, User4

];

SECTION APPLICATION;

The script reloads without problems in desktop application and when it comes to reloading in QMC, I got the error "Document open call failed. The document might require username and password.".

I also checked the box "data protection -> section access" in QMC -> Documents -> Reload and filled in the domain an the name of the QlikView Service-User (ourdomain\QVService) and also the password.

I also checked the box for data restriction in the configuration of the qvw file.

I also tried out this way: Section Access with QV Access Point - but without any success.

Can someone help me please?

Thanks in advance

Oliver

1 Solution

Accepted Solutions
kkkumar82
Specialist III
Specialist III

Try to put the domainname\Username in the Inline load you have created

View solution in original post

4 Replies
kkkumar82
Specialist III
Specialist III

Try to put the domainname\Username in the Inline load you have created

View solution in original post

kkkumar82
Specialist III
Specialist III

When u say NTNAME,

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME

Admin, User1

Admin, User2

User, User3

User, User4

];

Did u kept your Nameduser in the NTNAME column , if so, precede your name with your domain name\NTNAME

avinashelite

You need to include the Network/Domain name under NTNAME

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME

Admin, Network1\User1

Admin, Network1\User2

User, Network1\User3

User, Network1\User4

];

Check this thread for more details

Section Access

How to use Section Access with NT ID

QlikView Section Access Examples

oliverrichter
Contributor III
Contributor III
Author

OK, the missing domain name was the issue - now I don't get any error messages while reloading in QMC.

Now I'm  a single stept further...but the challenge is to keep some users away some data and I think, I don't understand section access correct, when I try this:

SECTION ACCESS;

LOAD * INLINE [

ACCESS,     NTNAME

ADMIN,        DOMAIN\USER1

ADMIN,        DOMAIN\USER2

USER,         DOMAIN\USER3

USER,         DOMAIN\USER4

];

SECTION APPLICATION;

LOAD * INLINE [

ACCESS,    BANKDATA

ADMIN,    1

USER,    0

];

I thought that I'm now able to do this in the application tab:

Bildschirmfoto 2016-12-04 um 18.51.27.png

Because of the application will only be opened in access point, now one can edit this configuration and the tab would only be shown, if the user is Admin. But I fear, that my thoughts are too simple. In QlikView there must be a harder way to do this

I also see now way to show the actual rights of the logged in user. That would help me to understand the way section access works (hopefully).

So could anyone be so kind and give me another hint?

Thanks in advance.

Oliver