topic Update RoleString in Management & Governance

Update RoleString

Ricardo_Gerhard — Thu, 19 Feb 2015 19:39:48 GMT

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 .

Re: Update RoleString

korsikov — Fri, 20 Feb 2015 09:54:47 GMT

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.

Re: Update RoleString

Ricardo_Gerhard — Mon, 23 Feb 2015 14:05:25 GMT

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.

Re: Update RoleString

korsikov — Mon, 23 Feb 2015 14:12:50 GMT

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"

Re: Update RoleString

Ricardo_Gerhard — Wed, 25 Feb 2015 20:52:53 GMT

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

I made it and works fine.

Thanks.

Re: Update RoleString

korsikov — Wed, 25 Feb 2015 21:18:02 GMT

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