Liran Zelkha has uploaded a new change for review.

Change subject: core : Remove import_export_vm action group from role 
UserInstanceManager
......................................................................

core : Remove import_export_vm action group from role UserInstanceManager

Role UserInstanceManager has import_export_vm action group, but there is no 
such action in UserPortal.
This patch removes the action group from the role.

Change-Id: Ie01408cc4c2f9d7de87abfb5e8500dc112dfb23c
Bug-Url: https://bugzilla.redhat.com/1072773
Signed-off-by: [email protected] <[email protected]>
---
A packaging/dbscripts/upgrade/03_05_0110_remove_role_from_user_manager_role.sql
1 file changed, 19 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/18/25718/1

diff --git 
a/packaging/dbscripts/upgrade/03_05_0110_remove_role_from_user_manager_role.sql 
b/packaging/dbscripts/upgrade/03_05_0110_remove_role_from_user_manager_role.sql
new file mode 100644
index 0000000..db1b75f
--- /dev/null
+++ 
b/packaging/dbscripts/upgrade/03_05_0110_remove_role_from_user_manager_role.sql
@@ -0,0 +1,19 @@
+Create or replace FUNCTION __temp_fix_user_vm_manager_role()
+RETURNS VOID
+   AS $procedure$
+   DECLARE
+   v_VM_ADMIN_ID UUID;
+BEGIN
+   v_VM_ADMIN_ID := 'def00012-0000-0000-0000-def000000012';
+
+-- Remove the import export vm action group from USER_VM_MANAGER role
+DELETE FROM roles_groups
+WHERE  role_id = v_VM_ADMIN_ID
+AND    action_group_id = 8;
+
+RETURN;
+END; $procedure$
+LANGUAGE plpgsql;
+
+SELECT __temp_fix_user_vm_manager_role();
+DROP function __temp_fix_user_vm_manager_role();
\ No newline at end of file


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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie01408cc4c2f9d7de87abfb5e8500dc112dfb23c
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Liran Zelkha <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to