Eli Mesika has uploaded a new change for review. Change subject: core: squash 03_00_0300_add_local_admin_user.sql ......................................................................
core: squash 03_00_0300_add_local_admin_user.sql Change-Id: I7e70e92809aeece7ae427059b1d37947874da6c7 Signed-off-by: Eli Mesika <emes...@redhat.com> --- D backend/manager/dbscripts/upgrade/03_00_0300_add_local_admin_user.sql 1 file changed, 0 insertions(+), 27 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/66/15466/1 diff --git a/backend/manager/dbscripts/upgrade/03_00_0300_add_local_admin_user.sql b/backend/manager/dbscripts/upgrade/03_00_0300_add_local_admin_user.sql deleted file mode 100644 index 19ca0f5..0000000 --- a/backend/manager/dbscripts/upgrade/03_00_0300_add_local_admin_user.sql +++ /dev/null @@ -1,27 +0,0 @@ --- insert local admin user to users table and assign superuser permissions -CREATE OR REPLACE FUNCTION __temp_add_admin_user() - RETURNS void AS -$BODY$ - DECLARE - v_user_id uuid ; -BEGIN - v_user_id := 'fdfc627c-d875-11e0-90f0-83df133b58cc'; - insert into users(user_id,name,domain,username,groups,status) - select v_user_id, 'admin', 'internal', 'admin@internal','',1 - where not exists (select 1 from users where user_id = v_user_id); - - insert into permissions(id,role_id,ad_element_id,object_id,object_type_id) - select uuid_generate_v1(), '00000000-0000-0000-0000-000000000001', v_user_id, getGlobalIds('system'), 1 - where not exists - (select 1 from permissions - where role_id = '00000000-0000-0000-0000-000000000001' and - ad_element_id = v_user_id and - object_id= getGlobalIds('system') and - object_type_id = 1); -END; $BODY$ - -LANGUAGE plpgsql; - -select __temp_add_admin_user(); -drop function __temp_add_admin_user(); - -- To view, visit http://gerrit.ovirt.org/15466 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I7e70e92809aeece7ae427059b1d37947874da6c7 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emes...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches