From 0ce71a2205af8e2fa4650709f7cae9e0557f1524 Mon Sep 17 00:00:00 2001 From: Pierre Guillot Date: Thu, 17 Oct 2019 09:25:45 +0200 Subject: [PATCH] SONAR-12595 fix documentation admin insert query --- .../sonar-docs/src/pages/instance-administration/security.md | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/server/sonar-docs/src/pages/instance-administration/security.md b/server/sonar-docs/src/pages/instance-administration/security.md index 55e18268aad..ed04933d0d0 100644 --- a/server/sonar-docs/src/pages/instance-administration/security.md +++ b/server/sonar-docs/src/pages/instance-administration/security.md @@ -56,7 +56,10 @@ update users set crypted_password = '$2a$12$uCkkXmhW5ThVK8mpBvnXOOJRLd64LJeHTeCk ``` If you've deleted `admin` and subsequently locked out the other users with global administrative permissions, you'll need to re-grant `admin` to a user with the following query: ``` -INSERT INTO user_roles(user_id, role) VALUES ((select id from users where login='mylogin'), 'admin'); +INSERT INTO user_roles(user_id, role, organization_uuid) +VALUES ((select id from users where login='mylogin'), +admin', +(select uuid from organizations where kee='default-organization')); ``` ## Authorization -- 2.39.5