Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;