Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
stuwannop
Contributor II

Section Access - dual right (ADMIN & USER)

Hi everyone

I recently encountered a problem in section access where for some reason I could not access a document through the access portal but I could access through the client. I understand that document access through the access point is done on USER credentials only so that solves the problem. 

My question is, can you set up section access so my NTNAME can be a USER and and ADMIN? I need to be able to develop the apps in the client but I also need full access to them through the access portal.

I hope that's clear - thanks for any help.

Stu

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: Section Access - dual right (ADMIN & USER)

Hi,

There is no way to do it that way. You will have to have a test user to test it in the accesspoint.

Bill

13 Replies
amit_saini
Honored Contributor III

Re: Section Access - dual right (ADMIN & USER)

Stuart,

Please see the attachment and check script .

Username: admin

Password: admin

Thanks,

AS

fkeuroglian
Honored Contributor

Re: Section Access - dual right (ADMIN & USER)

Hi Stuart, your user(domain/ntname) is in the secction acces? you have credencial to acces to it? and license in the acces point?

stuwannop
Contributor II

Re: Section Access - dual right (ADMIN & USER)

Yes - it is in the script as ADMIN, I have a user cal.

fkeuroglian
Honored Contributor

Re: Section Access - dual right (ADMIN & USER)

you should acces if you are in section acces and have license..

what error or msg do you have?

for other users works ok? to acces to the application in the acces point?

stuwannop
Contributor II

Re: Section Access - dual right (ADMIN & USER)

Thanks both. I get how it works my issue is if you set a user up as ADMIN in the section access script they cannot access the document through the access portal, but setting up as a USER you can.

So, my section access script looks something like this:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, Region

ADMIN, HEADOFFICE\JOHN.SMITH,*

USER,  HEADOFFICE\FRANK.GRIMES, NORTH

];

So in the example above, Frank Grimes can access the document through the portal (and only see North) but John Smith cannot - he gets the error - "you do not have access to this document" (qlikview licences are fine they are both USER CAL).

Now apparently you need USER access to access a doc through the portal so that means JOHN SMITH would need both USER AND ADMIN access (as he is the developer as well. I tried the Section Access script below but still not luck:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, Region

ADMIN, HEADOFFICE\JOHN.SMITH,*

USER,  HEADOFFICE\JOHN.SMITH,*

USER,  HEADOFFICE\FRANK.GRIMES, NORTH

];

As you can see I have JOHN.SMITH as a USER and ADMIN but I still get the same problem.

Thanks

Stu

stuwannop
Contributor II

Re: Section Access - dual right (ADMIN & USER)

As long as they are defined as a "USER" in the section access script it is fine, only when I define as an ADMIN does the problem occur through Access Point. My error message is in my other post.

Stu

Employee
Employee

Re: Section Access - dual right (ADMIN & USER)

Hi,

All users that access the document through the access point are considered "Users" and have only the rights that are given them in the reduction column.

Bill

fkeuroglian
Honored Contributor

Re: Re: Section Access - dual right (ADMIN & USER)

Stuart,

i assume you have INICIAL DATA REDUCTION in document properties.. (to use data reduction ok), you have check te strict exclusion too?

please uncheck and try it again

chauhans85
Esteemed Contributor

Re: Section Access - dual right (ADMIN & USER)

i Thought  we can provide only one kind of access

either partial access-> user access

full Access-> Admin

and i dont think if any person has full access then we can make him User with less permission.

i mean we can have either full or partial access

hope this helps

Community Browser