Locked out QVW

[#1]

As a newbie to QV I have made a mistake with Section Access.

I have logged with admin, then reloaded the data when apparently the permissions table in the DB was empty.

Saved the document, closed it.

Now I can't get in.

I have put days of work in it, and my backup is pretty old.

Is there any solution? Can I atleast save the script?

[flipside]

Further to Bill's answer, I tend to put all my security in the document as a load * inline, but you could hard code just the admin password with user security loaded from the DB. This would cover you in case the data in the DB had been deleted.

Section Access;
SecTable:
LOAD * INLINE
[USERID, PASSWORD, ACCESS
Admin, adminpassword, Admin];

LOAD USERID,
     PASSWORD,
     ACCESS
FROM
[Security.xlsx]
(ooxml, embedded labels, table is Sheet1);

Section Application;

flipside

[#3]

Thanks flipside,

I understand that it is a possible solution.

Probably I will use it myself.

The issue is that in various places this sort of solution is regarded as bad practice.

[flipside]

I agree, at first it seems odd, but if the script is placed in the hidden script section (which is itself passworded), then I don't think it's recoverable from the file without knowing the passwords, so is secure. Unless someone knows otherwise!

[sohailansari201]

Not sure about this but just want to throw out this idea:

Let's say a user is locked out of QVW file because of Section Access. The sample Section Access security was like this:

ACCESS,SECURITY,USER_AD_NAME

ADMIN,*,COMPDOMAIN\USER1

ADMIN,*,COMPDOMAIN\USER2

But you forgot to add your user name as the ADMIN, then you can either try to login as either USER1 or USER2, install QlikView and open the file and edit the script and add your username as ADMIN.

Or alternately, install a Windows Server on a stand alone machine and keep the name of this machine as COMPDOMAIN. Create a user on this machine called USER1 and login with this user. Install QlikView and the license. Then just try to open this file on this computer. This should work.

Thanks.