Grant for last View
diff --git a/src/main/resources/db/migration/V0_12__CREATE_CBD_DB.sql b/src/main/resources/db/migration/V0_12__CREATE_CBD_DB.sql index 9941eac..b0a1bf2 100644 --- a/src/main/resources/db/migration/V0_12__CREATE_CBD_DB.sql +++ b/src/main/resources/db/migration/V0_12__CREATE_CBD_DB.sql
@@ -672,6 +672,10 @@ LEFT OUTER JOIN tbl_communication com ON (com.fk_contact_id = c.fk_contact_id AND com.fk_communication_type=1 ) ; +ALTER VIEW public.VW_DETAILED_CONTACT + OWNER TO CBD_SERVICE; +GRANT ALL ON TABLE public.VW_DETAILED_CONTACT TO CBD_SERVICE; +