topic Locked out - Section Access in QlikView

Locked out - Section Access

bullish35 — Thu, 09 Dec 2010 01:01:58 GMT

Similar tragic story as other users have documented when being locked out of their apps. Here's my twist:

Without realizing that there are only two types of access: ADMIN and USER, I implemented section access, assigned user ids, passwords, and a 'cluster' column based on access levels that do not/can not exist.

By chance, the script included two lines for access type 'USER'. Unfortunately, the 'cluster' of data that the users should be able to view do not exist in the Section Application map.

I only have the latest version of the .qvw file available - no backup. When I try to publish the .qvw, the tasks fail. Am I really out of luck? Is it possible to create a custom access type? For example, 'EXECUTIVE' instead of 'ADMIN'.

Any suggestions would be greatly appreciated. Here's the script:

SectionAccess:

Section Access
LOAD * INLINE [
ACCESS, USERID, PASSWORD, ID
EXECUTIVE, EXEC, E, *
CHANNEL_HEAD, CHAN, CH
DEVELOPER, DEV, D, *
USER, DEMO2, P, B
USER, DEMO3, P, C
]

Section Application
LOAD * INLINE [
Channel, ID
RLO, R
Other, O
EJ, E
M, M
MO / SC, MOSC
SM, SM
WH, W

]

[:'(]

Locked out - Section Access

Oleg_Troyansky — Thu, 09 Dec 2010 07:25:40 GMT

Ellen,

unfortunately, field ACCESS can only accept 2 possible values - ADMIN or USER, no other values would work.

As tragic as it sounds, you are probably out of luck - try to scramble and find any backup versions. Maybe you used auto-save? Maybe you e-mailed a copy of the document to someone?

This is a common trap - once you lock yourself out of the document, there is no way to unlock it...

good luck!

Locked out - Section Access

bullish35 — Thu, 09 Dec 2010 19:49:56 GMT

Thank you Oleg.

Locked out - Section Access

maneshkhottcpl — Fri, 10 Dec 2010 03:13:30 GMT

Hi,

If u send me the application i can try to help u.