Martin Peřina has uploaded a new change for review.

Change subject: tools: Fix permissions for users added by engine-manage-domains
......................................................................

tools: Fix permissions for users added by engine-manage-domains

Fix permissions for users added by engine-manage-domains by setting
last_admin_check_status to true. The same is done in
AddPermissionCommand if admin role is assigned to user.

Change-Id: Id7565f00d26cf641efd82aa5508deece9f4ee7cf
Bug-Url: https://bugzilla.redhat.com/1057087
Signed-off-by: Martin Perina <[email protected]>
---
M packaging/dbscripts/common_sp.sql
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/85/24485/1

diff --git a/packaging/dbscripts/common_sp.sql 
b/packaging/dbscripts/common_sp.sql
index ca00f20..8167a24 100644
--- a/packaging/dbscripts/common_sp.sql
+++ b/packaging/dbscripts/common_sp.sql
@@ -337,7 +337,7 @@
    -- bytes:
    v_external_id := decode(replace(v_user_id::text, '-', ''), 'hex');
 
-insert into users(user_id,external_id,name,domain,username,groups,active) 
select input_uuid, v_external_id, v_name, v_domain, v_user_name,'',true where 
not exists (select user_id,name,domain,username,groups,active from users where 
user_id = input_uuid);
+insert into 
users(user_id,external_id,name,domain,username,groups,active,last_admin_check_status)
 select input_uuid, v_external_id, v_name, v_domain, v_user_name,'',true,true 
where not exists (select user_id,name,domain,username,groups,active from users 
where user_id = input_uuid);
 
 insert into permissions(id,role_id,ad_element_id,object_id,object_type_id) 
select v_permission_id, '00000000-0000-0000-0000-000000000001', input_uuid, 
getGlobalIds('system'), 1 where not exists(select 
role_id,ad_element_id,object_id,object_type_id from permissions where role_id = 
'00000000-0000-0000-0000-000000000001' and ad_element_id = input_uuid and 
object_id= getGlobalIds('system') and object_type_id = 1);
 END; $BODY$


-- 
To view, visit http://gerrit.ovirt.org/24485
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id7565f00d26cf641efd82aa5508deece9f4ee7cf
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: ovirt-engine-3.4
Gerrit-Owner: Martin Peřina <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to