Qlik Community

Deployment & Management

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

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Ricardo_Gerhard
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
Ricardo_Gerhard
Employee
Employee
Author

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

I made it and works fine.

Thanks.

Ricardo Gerhard
OEM Solution Architect
LATAM

View solution in original post

5 Replies
korsikov
Partner - Specialist III
Partner - Specialist III

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.

Ricardo_Gerhard
Employee
Employee
Author

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
Partner - Specialist III
Partner - Specialist III

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"

Ricardo_Gerhard
Employee
Employee
Author

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
Partner - Specialist III
Partner - Specialist III

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