1 Reply Latest reply: Jun 10, 2010 4:50 AM by Anatoly Pyatygo RSS

    Problem when defining access restrictions from a database table

    dvariado

      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