5 Replies Latest reply: Feb 25, 2015 4:18 PM by alexander korsikov RSS

    Update RoleString

    Ricardo Gerhard

      Suppose I´m lost credentials from RootAdmin users and need to access QMC, there is a way to restore this access directly by database update to a new user registered?

       

      I found this update after altered config log level in PostgreSQL database:

      SET autocommit=true

      UPDATE ""Users""

         SET ""UserId"" = $1,

          ""UserDirectory"" = $2,

          ""Name"" = $3,

          ""RolesString"" = $4,

          ""Inactive"" = $5,

          ""Deleted"" = $6,

          ""CreatedDate"" = $7,

          ""ModifiedDate"" = $8,

          ""SyncDate"" = $9,

          ""ModifiedByUserName"" = $10

      WHERE ""ID"" = $11",

      "parameters:

      $1 = 'administrator',

      $2 = 'WIN-I3L69AIS9MR',

      $3 = 'administrator',

      $4 = 'RootAdmin',

      $5 = 'f',

      $6 = 'f',

      $7 = '2015-02-19 11:19:21.826618',

      $8 = '2015-02-19 18:53:12.82906',

      $9 = '1753-01-01 00:00:00',

      $10 = 'WIN-I3L69AIS9MR\svc_qlikview',

      $11 = 'e4b2dcf0-7aa6-452a-805c-f2913a542f27'"

      COMMIT

      I tried update in users table and didn´t work .