Gilad Chaplik has uploaded a new change for review. Change subject: db: insert_predefined_roles.sql clean-up ......................................................................
db: insert_predefined_roles.sql clean-up remove later added quota role and action group link Change-Id: I0fe04f3d3ca8315a715569359cca4b5f3ca38159 Signed-off-by: Gilad Chaplik <[email protected]> --- M backend/manager/dbscripts/insert_predefined_roles.sql 1 file changed, 0 insertions(+), 11 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/46/10746/1 diff --git a/backend/manager/dbscripts/insert_predefined_roles.sql b/backend/manager/dbscripts/insert_predefined_roles.sql index 2ccc269..e283a88 100644 --- a/backend/manager/dbscripts/insert_predefined_roles.sql +++ b/backend/manager/dbscripts/insert_predefined_roles.sql @@ -468,17 +468,6 @@ INSERT INTO roles(id,name,description,is_readonly,role_type) select v_TEMPLATE_USER_ID,'TemplateUser','Template User',true,2 where not exists (select id,name,description,is_readonly,role_type from roles where id= v_TEMPLATE_USER_ID and name='TemplateUser' and description='Template User' and is_readonly=true and role_type=2); --------------- ---QUOTA_CONSUMER_USER role --------------- --- Add new role for quota adminstrator -delete from roles_groups where role_id = v_QUOTA_CONSUMER_USER_ID; -INSERT INTO roles(id,name,description,is_readonly,role_type) select v_QUOTA_CONSUMER_USER_ID, 'QuotaConsumer','Quota consumer',true,2 where -not exists (select id,name,description,is_readonly,role_type from roles where id= v_QUOTA_CONSUMER_USER_ID and name='QuotaConsumer' and description='Quota consumer' and is_readonly=true and role_type=2); - --- Add role to consume from quota -INSERT INTO roles_groups(role_id,action_group_id) VALUES(v_QUOTA_CONSUMER_USER_ID, 901); - ---Vm Groups --CREATE_VM INSERT INTO roles_groups(role_id,action_group_id) VALUES(v_TEMPLATE_USER_ID,1); -- To view, visit http://gerrit.ovirt.org/10746 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I0fe04f3d3ca8315a715569359cca4b5f3ca38159 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Gilad Chaplik <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
