Ravi Nori has uploaded a new change for review. Change subject: core : Manage domains does not add permissions for user ......................................................................
core : Manage domains does not add permissions for user engine-managed-domains does not add permissions for user when invoked with --add-permissions Change-Id: I934a89fa376394001fdc783afcbc88e4466b7d26 Bug-Url: https://bugzilla.redhat.com/1179886 Signed-off-by: Ravi Nori <rn...@redhat.com> --- M packaging/dbscripts/common_sp.sql 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/53/36653/1 diff --git a/packaging/dbscripts/common_sp.sql b/packaging/dbscripts/common_sp.sql index 3aa5c52..e9099b5 100644 --- a/packaging/dbscripts/common_sp.sql +++ b/packaging/dbscripts/common_sp.sql @@ -281,7 +281,7 @@ select roles.id into input_role_id from roles where roles.name = v_role_name; -- The external identifier is the user identifier converted to an array of -- bytes: - insert into users(user_id,external_id,name,domain,username,groups,active,last_admin_check_status) select gen_user_id, v_domain_entry_id, v_user_name, v_domain, v_user_name,'',true,true where not exists (select gen_user_id,name,domain,username,groups,active from users where external_id = v_domain_entry_id); + insert into users(user_id,external_id,name,domain,username,last_admin_check_status) select gen_user_id, v_domain_entry_id, v_user_name, v_domain, v_user_name,true where not exists (select 1 from users where external_id = v_domain_entry_id); insert into permissions(id,role_id,ad_element_id,object_id,object_type_id) select uuid_generate_v1(), input_role_id, gen_user_id, getGlobalIds('system'), 1 where not exists(select role_id,ad_element_id,object_id,object_type_id from permissions where role_id = input_role_id and ad_element_id = gen_user_id and object_id= getGlobalIds('system') and object_type_id = 1); END; $BODY$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/36653 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I934a89fa376394001fdc783afcbc88e4466b7d26 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Ravi Nori <rn...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
