Qlik Community

Qlik Sense Deployment & Management

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Employee
Employee

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
Highlighted
Partner
Partner

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.

Highlighted
Employee
Employee

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
Highlighted
Partner
Partner

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"

Highlighted
Employee
Employee

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

Highlighted
Partner
Partner

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