--- /home/andrew/bf/root/upgrade.crake/HEAD/origin-REL9_5_STABLE.sql.fixed 2021-09-12 16:04:40.281098310 -0400 +++ /home/andrew/bf/root/upgrade.crake/HEAD/converted-REL9_5_STABLE-to-HEAD.sql.fixed 2021-09-12 16:04:40.306098310 -0400 @@ -66,9 +66,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -7199,9 +7199,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -8042,9 +8042,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -26509,9 +26509,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -26851,9 +26851,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -26949,9 +26947,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -30182,9 +30180,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -30416,13 +30414,25 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; -- +-- Name: FUNCTION dblink_connect_u(text); Type: ACL; Schema: public; Owner: buildfarm +-- + +REVOKE ALL ON FUNCTION public.dblink_connect_u(text) FROM PUBLIC; + + +-- +-- Name: FUNCTION dblink_connect_u(text, text); Type: ACL; Schema: public; Owner: buildfarm +-- + +REVOKE ALL ON FUNCTION public.dblink_connect_u(text, text) FROM PUBLIC; + + +-- -- PostgreSQL database dump complete -- @@ -30521,9 +30531,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -30626,9 +30634,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -30870,9 +30878,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -30982,9 +30990,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -31073,9 +31079,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -31164,9 +31168,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -32376,9 +32380,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -32467,9 +32469,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -32770,9 +32772,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -32861,9 +32861,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -35026,9 +35026,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -35228,9 +35226,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -36391,9 +36389,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -36552,9 +36550,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -36694,9 +36692,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -36872,9 +36870,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -39062,9 +39060,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -39976,9 +39972,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -42687,9 +42683,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43007,9 +43003,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43125,9 +43119,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43216,9 +43208,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43321,9 +43311,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43490,9 +43480,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43660,9 +43650,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43765,9 +43753,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -43938,9 +43924,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -44029,9 +44013,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -45473,9 +45457,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -46368,9 +46352,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -47325,9 +47309,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -47372,9 +47354,7 @@ -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -47511,7 +47491,8 @@ -- CREATE TYPE public.arrayrange AS RANGE ( - subtype = integer[] + subtype = integer[], + multirange_type_name = public.arraymultirange ); @@ -47534,7 +47515,8 @@ -- CREATE TYPE public.cashrange AS RANGE ( - subtype = money + subtype = money, + multirange_type_name = public.cashmultirange ); @@ -47621,6 +47603,7 @@ INTERNALLENGTH = 16, INPUT = public.int44in, OUTPUT = public.int44out, + SUBSCRIPT = raw_array_subscript_handler, ELEMENT = integer, CATEGORY = 'x', PREFERRED = true, @@ -47668,6 +47651,7 @@ CREATE TYPE public.float8range AS RANGE ( subtype = double precision, + multirange_type_name = public.float8multirange, subtype_diff = float8mi ); @@ -48194,6 +48178,7 @@ CREATE TYPE public.textrange AS RANGE ( subtype = text, + multirange_type_name = public.textmultirange, collation = pg_catalog."C" ); @@ -249867,9 +249854,9 @@ -- COPY public.test_tsquery (txtkeyword, txtsample, keyword, sample) FROM stdin; -'New York' new & york | big & apple | nyc 'new' & 'york' ( 'new' & 'york' | 'big' & 'appl' ) | 'nyc' +'New York' new & york | big & apple | nyc 'new' & 'york' 'new' & 'york' | 'big' & 'appl' | 'nyc' Moscow moskva | moscow 'moscow' 'moskva' | 'moscow' -'Sanct Peter' Peterburg | peter | 'Sanct Peterburg' 'sanct' & 'peter' ( 'peterburg' | 'peter' ) | 'sanct' & 'peterburg' +'Sanct Peter' Peterburg | peter | 'Sanct Peterburg' 'sanct' & 'peter' 'peterburg' | 'peter' | 'sanct' & 'peterburg' 'foo bar qq' foo & (bar | qq) & city 'foo' & 'bar' & 'qq' 'foo' & ( 'bar' | 'qq' ) & 'citi' \. @@ -253535,22 +253522,10 @@ ALTER TABLE rls_regress_schema.rls_tbl_force ENABLE ROW LEVEL SECURITY; -- --- Name: DATABASE regression; Type: ACL; Schema: -; Owner: buildfarm --- - -REVOKE ALL ON DATABASE regression FROM PUBLIC; -REVOKE ALL ON DATABASE regression FROM buildfarm; -GRANT ALL ON DATABASE regression TO buildfarm; -GRANT CONNECT,TEMPORARY ON DATABASE regression TO PUBLIC; - - --- -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: buildfarm -- -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM buildfarm; -GRANT ALL ON SCHEMA public TO buildfarm; +REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; @@ -253558,9 +253533,6 @@ -- Name: TABLE my_credit_card_normal; Type: ACL; Schema: public; Owner: buildfarm -- -REVOKE ALL ON TABLE public.my_credit_card_normal FROM PUBLIC; -REVOKE ALL ON TABLE public.my_credit_card_normal FROM buildfarm; -GRANT ALL ON TABLE public.my_credit_card_normal TO buildfarm; GRANT SELECT ON TABLE public.my_credit_card_normal TO PUBLIC; @@ -253568,9 +253540,6 @@ -- Name: TABLE my_credit_card_secure; Type: ACL; Schema: public; Owner: buildfarm -- -REVOKE ALL ON TABLE public.my_credit_card_secure FROM PUBLIC; -REVOKE ALL ON TABLE public.my_credit_card_secure FROM buildfarm; -GRANT ALL ON TABLE public.my_credit_card_secure TO buildfarm; GRANT SELECT ON TABLE public.my_credit_card_secure TO PUBLIC; @@ -253578,9 +253547,6 @@ -- Name: TABLE my_credit_card_usage_normal; Type: ACL; Schema: public; Owner: buildfarm -- -REVOKE ALL ON TABLE public.my_credit_card_usage_normal FROM PUBLIC; -REVOKE ALL ON TABLE public.my_credit_card_usage_normal FROM buildfarm; -GRANT ALL ON TABLE public.my_credit_card_usage_normal TO buildfarm; GRANT SELECT ON TABLE public.my_credit_card_usage_normal TO PUBLIC; @@ -253588,9 +253554,6 @@ -- Name: TABLE my_credit_card_usage_secure; Type: ACL; Schema: public; Owner: buildfarm -- -REVOKE ALL ON TABLE public.my_credit_card_usage_secure FROM PUBLIC; -REVOKE ALL ON TABLE public.my_credit_card_usage_secure FROM buildfarm; -GRANT ALL ON TABLE public.my_credit_card_usage_secure TO buildfarm; GRANT SELECT ON TABLE public.my_credit_card_usage_secure TO PUBLIC; @@ -253598,9 +253561,6 @@ -- Name: TABLE my_property_normal; Type: ACL; Schema: public; Owner: buildfarm -- -REVOKE ALL ON TABLE public.my_property_normal FROM PUBLIC; -REVOKE ALL ON TABLE public.my_property_normal FROM buildfarm; -GRANT ALL ON TABLE public.my_property_normal TO buildfarm; GRANT SELECT ON TABLE public.my_property_normal TO PUBLIC; @@ -253608,9 +253568,6 @@ -- Name: TABLE my_property_secure; Type: ACL; Schema: public; Owner: buildfarm -- -REVOKE ALL ON TABLE public.my_property_secure FROM PUBLIC; -REVOKE ALL ON TABLE public.my_property_secure FROM buildfarm; -GRANT ALL ON TABLE public.my_property_secure TO buildfarm; GRANT SELECT ON TABLE public.my_property_secure TO PUBLIC;