Problem when defining access restrictions from a database table

Thu, 10 Jun 2010 08:42:51 GMT

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

Problem when defining access restrictions from a database table

sparur — Thu, 10 Jun 2010 08:50:41 GMT

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;

topic Problem when defining access restrictions from a database table in QlikView

Problem when defining access restrictions from a database table

Problem when defining access restrictions from a database table