Liran Zelkha has uploaded a new change for review.

Change subject: core : Remove manipulating instance VM action group from role 
UserInstanceManager
......................................................................

core : Remove manipulating instance VM action group from role 
UserInstanceManager

Role UserInstanceManager has manipulating instance 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_0150_remove_import_export_permission_from_user_instance_manager_role.sql
1 file changed, 19 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/59/26059/1

diff --git 
a/packaging/dbscripts/upgrade/03_05_0150_remove_import_export_permission_from_user_instance_manager_role.sql
 
b/packaging/dbscripts/upgrade/03_05_0150_remove_import_export_permission_from_user_instance_manager_role.sql
new file mode 100644
index 0000000..db1b75f
--- /dev/null
+++ 
b/packaging/dbscripts/upgrade/03_05_0150_remove_import_export_permission_from_user_instance_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/26059
To unsubscribe, visit http://gerrit.ovirt.org/settings

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

Reply via email to