Eli Mesika has uploaded a new change for review. Change subject: core: check DB objects before upgrade ......................................................................
core: check DB objects before upgrade Verify that Material Views are created with user 'engine' If other user is attempting to create a MV, the database throws an error Change-Id: I50229dc028bc320405a7fc501a7f80f9ab23c6f3 Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=960063 Signed-off-by: Eli Mesika <emes...@redhat.com> --- M packaging/dbscripts/materialized_views_sp.sql 1 file changed, 4 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/31/17931/1 diff --git a/packaging/dbscripts/materialized_views_sp.sql b/packaging/dbscripts/materialized_views_sp.sql index 442c84a..dffae84 100644 --- a/packaging/dbscripts/materialized_views_sp.sql +++ b/packaging/dbscripts/materialized_views_sp.sql @@ -77,6 +77,10 @@ RAISE EXCEPTION 'Materialized view % already exists.', v_matview; END IF; + IF current_user != 'engine' THEN + RAISE EXCEPTION 'Materialized view % should be created with user ''engine''.', + v_matview; + END IF; EXECUTE 'REVOKE ALL ON ' || v_view_name || ' FROM PUBLIC'; -- To view, visit http://gerrit.ovirt.org/17931 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I50229dc028bc320405a7fc501a7f80f9ab23c6f3 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
