topic Overriding Section Access in QlikView

Overriding Section Access

Mon, 15 Jun 2009 15:09:31 GMT

Hi there!

Chief designer is in holidays and i have received complaints about an application that is guarded by an inline section access.

How can i open the app and override the section access? I have something in mind like pressing shift or ctrl and double-clicking the application. That didn't work yet.

Any help greatly appreciated.

Best regards /Jan

Overriding Section Access

Mon, 15 Jun 2009 15:28:06 GMT

Are you talking about accessing a hidden script? Or do you want to change the script so that the data reduction invoked by section access is not actioned?

Regards,

Gordon

Overriding Section Access

Mon, 15 Jun 2009 15:41:21 GMT

Hi Gordon,

thanx 4 your answer!

The application is protected by a section access statement that is included in the script:

Section Access
27.03.2009 05:54:54: 0016 LOAD * INLINE [
27.03.2009 05:54:54: 0017 ACCESS,USERID,PASSWORD, NTNAME, WERK
27.03.2009 05:54:54: 0018 ADMIN,,,hk,*
27.03.2009 05:54:54: 0019 ADMIN,,,bn,*
27.03.2009 05:54:54: 0020 ADMIN,,,qvpservice,*
27.03.2009 05:54:54: 0021 ADMIN,,,SALLER,*
27.03.2009 05:54:54: 0022 USER,,,BO,2030
27.03.2009 05:54:54: 0023 USER,,,ELEBEAU,2030
27.03.2009 05:54:54: 0024 USER,,,ELEBEAU,2040
27.03.2009 05:54:54: 0025 USER,,,JMCMAHON,2040
27.03.2009 05:54:54: 0026 USER,,,MLUCHT,2030
27.03.2009 05:54:54: 0027 USER,,,SLUCHT,2030
27.03.2009 05:54:54: 0028 USER,,,DRETANA,2030
27.03.2009 05:54:54: 0029 USER,,,ECHICO,2030
27.03.2009 05:54:54: 0030 USER,,,SLEWIS,2030
27.03.2009 05:54:54: 0031 USER,,,DYON,2030
27.03.2009 05:54:54: 0032 USER,,,JCHEEVER,2020
27.03.2009 05:54:54: 0033 USER,,,JCHEEVER,2030
27.03.2009 05:54:54: 0034 USER,,,JCHEEVER,2040
27.03.2009 05:54:54: 0035 USER,,,CPOLESHEK,2040
27.03.2009 05:54:54: 0036 USER,,,BRESS,2040
27.03.2009 05:54:54: 0037 USER,,,KOC,2040
27.03.2009 05:54:54: 0038 USER,,,DOM,4106
27.03.2009 05:54:54: 0065 ]
27.03.2009 05:54:54: 5 Felder gefunden: ACCESS, USERID, PASSWORD, NTNAME, WERK, 47 Sätze erhalten
27.03.2009 05:54:54: 0066 Section Application

That prohibits to open the application for all other users. I think i remember some kind of trick to open the application without passing the section access. Do you happen to know something about this?

Best regards

Jan

Overriding Section Access

Mon, 15 Jun 2009 15:55:56 GMT

Jan,

As far as I know there is no 'back door' with Section Access.

I asume you want to add/amend user accesses? Can you not get at the script using Enterprise?

Incidentally, I hold all my section access data in a spreadsheet (one sheet per document) that resides on the server and has strict object authorities to prevent unauthorised access. This I believe has two advantages

1 accesses are all together in the same place

2 they are seperate from the documents so do not need a Qlikview developer to maintain access control

Regards,

Gordon

Overriding Section Access

Mon, 15 Jun 2009 15:59:25 GMT

Hi Gordon,

this is how we do it, too. Usually.. I do not why it was done differently in this application.

I am simply trying to access it (open it). I can't, due to section access and because it was forgotten to add my user name.

If there is no solution, the user has to wait until the programmer is back in place...

Cheers & thx /J

Overriding Section Access

Wed, 12 Aug 2009 15:38:37 GMT

Hi Gordon,

Could you please explain me the steps how to achieve the same as you said here? as i need the same implementation.

1 accesses are all together in the same place

2 they are seperate from the documents so do not need a Qlikview developer to maintain access control "

Thanks ,

Mahasweta