topic Section Access and Publisher problem in QlikView

Section Access and Publisher problem

Mon, 26 Jan 2026 18:19:17 GMT

So I've successfully implemented section access to hide/show tabs based on AD logins for my users.

However, when I go try to load the QVW onto the portal with publisher, it fails. It says the QVW might need a user name and password and can't open it.

How do I give publisher rights to the file in my section access?

I tried putting in a "SERIAL" column in my section access and inserting the servers license number but that did not work.

Re: Section Access and Publisher problem

Thu, 19 Jul 2012 19:49:50 GMT

Anyone have any ideas?

Re: Section Access and Publisher problem

rwunderlich — Thu, 19 Jul 2012 22:36:16 GMT

You must include the Publisher service userid in your SA table.

-Rob

Re: Section Access and Publisher problem

Fri, 20 Jul 2012 11:11:04 GMT

Does that go under my USERID column? What do I do for password? Is there anything else I need to put as well?

Re: Section Access and Publisher problem

Fri, 20 Jul 2012 13:32:15 GMT

Thanks. I got publisher to reload the qvw.

Now I have a new problem. Once its reloaded and goes into the access point, I specify what groups can see it in the access point and then section access reduces them further to the specific people I said in the script. However, when they try to open it in the access point it tells them they dont have access. Even myself, as the admin with full rights to every tab in the section access, can see it in access point but is denied access to the document.

Any ideas?

Re: Section Access and Publisher problem

Mon, 23 Jul 2012 06:35:45 GMT

Hi,

can you provide your section access table, with some sample values?

it should be with the following structure for domain users:

ACCESS NTNAME USERID PASSWORD <OTHER_FIELDS>

USER <domain_name>\<user_name> * * <specific values>

regards

Re: Section Access and Publisher problem

Mon, 23 Jul 2012 12:17:37 GMT

Section Access;

LOAD * INLINE [

ACCESS, NTNAME,

ADMIN, JOHN.DOE,

ADMIN, JANE.DOE,

USER, JOSHUA.SMITH,

USER, ASHLEY.SMITH,

ADMIN, <my publisher account>

];

Section Application;

LOAD * INLINE [

NTNAME, TAB1, TAB2, TAB3, TAB4, TAB5, TAB6,

JOHN.DOE, X, X, X, X, X, X,

etc..

Publisher account, X, X, X, X, X, X,

];

Re: Section Access and Publisher problem

Mon, 23 Jul 2012 14:56:25 GMT

This new problem is becoming urgent if someone could help that would be great.

Re: Section Access and Publisher problem

rwunderlich — Mon, 23 Jul 2012 18:25:34 GMT

As far as I know, you cannot use NTNAME (or any the other special SA fields) as the Data link column. You must use a new name. If I'm correct, your problem is likely that you have strict exclusion checked and the user is linked to no data.

-Rob

Re: Section Access and Publisher problem

Mon, 23 Jul 2012 18:29:50 GMT

Well whats odd is that it works correctly if my users go to the location of the file. It will only open for those in the list and reduces correctly while denying anyone who is not on the list.

If I take that EXACT same file and load it into publisher to go onto the access point, it denies everyone from accessing the qvw on the access point. Even me, who has admin/rights to all data in the qvw.

Could this be a bug?

Re: Section Access and Publisher problem

rwunderlich — Mon, 23 Jul 2012 18:40:44 GMT

One difference is that when opening from the server, everyone's access level is USER. There is no ADMIN level.

-Rob

Re: Section Access and Publisher problem

Mon, 23 Jul 2012 19:39:56 GMT

So if I choose "Initial selection based on section access" instead of "initial data reduction based on section access" and "Strict exclusion" it allows me and my users to open it via the access point.

But then it gives you the current selection of your NTNAME. If you clear it, you cant get it back and all the tabs you're supposed to see disappear. Then you get sent to the first tab, regardless of whether you have access to it or not.

This whole thing is odd.

Re: Section Access and Publisher problem

Tue, 25 Jun 2013 12:13:37 GMT

Hi Ethan,

Can you please let me know how to restrict Tab access using section access? Thanks a lot!

Mayank

Re: Section Access and Publisher problem

sanketkhunte — Thu, 10 Oct 2013 11:23:24 GMT

Hi Friends,

From above block Ethan can reload the QVW through publisher after providing Publisher USERID and PASSWORD.

Can anyone anw. me what actually PUBLISHER'S USERID AND PASSWORD ?? Please tell me the example if have.

Sanket.