Problem when defining access restrictions from a database table

[#1]

Hello,

I´m trying to define the users, access and passwords of the system through a database table, since it's easier to configure the security than using an .csv file or the inline option. So, I created a table in a sql database with the following fields:

USERID, PASSWORD AND ACCESS.

Also, I put the following lines in the document script section:

LOAD ACCESS,
PASSWORD,
USERID;
SQL SELECT ACCESS,
PASSWORD,
USERID
FROM p.USERS;

However, even if the database connection works, when I input the user when trying to access the qlikview document, qlikview doesn't accept any of the users that I've created. So, after a number of trials, the document is closed.

Does someone have some clue about this type o problem?

regards,

david

[sparur · Accepted solution]

Hello, David.

Try convert values of all fields in upper case:

LOAD

Upper(ACCESS) as ACCESS,
Upper(PASSWORD) as PASSWORD,
Upper(USERID) as USERID;
SQL SELECT ACCESS,
PASSWORD,
USERID
FROM p.USERS;