Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Employee
Employee

Update RoleString

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 .

Ricardo Gerhard
OEM Solution Architect
LATAM
1 Solution

Accepted Solutions
Employee
Employee

Re: Update RoleString

It´s necessary verify all fields and restart services after changed.

I made it and works fine.

Thanks.

Ricardo Gerhard
OEM Solution Architect
LATAM
5 Replies
korsikov
Valued Contributor II

Re: Update RoleString

it should be understood that the authorization passes through windows, that is, if you forget the password it is necessary to restore password windows user.

If you have a table of users for users that you know the login password, just set it to the paramter RolesString to RootAdmin.

Employee
Employee

Re: Update RoleString

Hi Alexander,

I had tried to update RoleString but didn´t work. My problem is the customer that lost all access and need a workaround to reestablish admin access.

Ricardo Gerhard
OEM Solution Architect
LATAM
korsikov
Valued Contributor II

Re: Update RoleString

This is very strange. Before I write a response, modeled such an operation on my server. Everything worked correctly.

Can record videos of your actions? It is also interesting to see the contents of the table "users"

Employee
Employee

Re: Update RoleString

It´s necessary verify all fields and restart services after changed.

I made it and works fine.

Thanks.

Ricardo Gerhard
OEM Solution Architect
LATAM
korsikov
Valued Contributor II

Re: Update RoleString

Please mark the appropriate replies as helpful / correct so Wool team and community  members know that your question has been answered to your satisfaction

Community Browser