SELECT has_database_privilege('myuser1', 'mydb1', 'CONNECT')
-- false

SELECT current_database(), has_function_privilege('myuser1', 16437, 'EXECUTE')
-- mydb1, true

CREATE ROLE myuser1;

CREATE DATABASE mydb1;

REVOKE ALL ON DATABASE "mydb1" FROM PUBLIC;

\c mydb1

SET SESSION AUTHORIZATION postgres;

REVOKE ALL ON SCHEMA public FROM PUBLIC;

CREATE TABLE mytbl1 ( field1 integer );

SELECT has_table_privilege('myuser1', 'mytbl1', 'SELECT');
-- false

CREATE OR REPLACE FUNCTION myfn1 ()
RETURNS integer AS
$$
BEGIN
    RETURN 1;
END
$$ LANGUAGE plpgsql;

SELECT myfn1();

SELECT oid, * FROM pg_proc WHERE proname='myfn1';

SELECT current_database(), has_function_privilege('myuser1', 130458, 'EXECUTE');
-- true

SELECT fn_schema, fn_name, fn_oid, rolname, rolcanlogin::int, rolsuper::int, string_agg(privilege_type, ',' order by privilege_type) as "Granted", fn_args
FROM (SELECT nspname AS fn_schema, proname as fn_name, pg_proc.oid AS fn_oid, pg_get_function_arguments(pg_proc.oid) AS fn_args
	FROM pg_proc INNER JOIN pg_namespace ON pg_proc.pronamespace = pg_namespace.oid
	WHERE  nspname not like 'pg_%' and nspname <> 'information_schema'
) pr
CROSS JOIN pg_roles ro
CROSS JOIN (SELECT unnest('{EXECUTE}'::text[]) AS privilege_type) pt
WHERE has_function_privilege(rolname, fn_oid, privilege_type) = true
	and rolreplication = false and rolsuper = false --and rolcanlogin = true
	and rolname not like 'pg_%'
GROUP BY 1,2,8,3,4,5,6
ORDER BY 1,2,8,4

pg_dump -U postgres -d mydb1 --schema-only | grep -vP '^\s*(#|;|$)' | grep -vP '^--'

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
CREATE FUNCTION public.myfn1() RETURNS integer
    LANGUAGE plpgsql
    AS $$
BEGIN
    RETURN 1;
END
$$;
ALTER FUNCTION public.myfn1() OWNER TO postgres;
SET default_tablespace = '';
SET default_table_access_method = heap;
CREATE TABLE public.mytbl1 (
    field1 integer
);
ALTER TABLE public.mytbl1 OWNER TO postgres;
REVOKE ALL ON SCHEMA public FROM PUBLIC;

REVOKE ALL ON FUNCTION ... FROM PUBLIC;

ALTER DEFAULT PRIVILEGES IN SCHEMA public FOR ROLE postgres REVOKE ALL ON FUNCTIONS FROM PUBLIC;

CREATE SCHEMA myschema1
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema1 FOR ROLE postgres REVOKE ALL ON FUNCTIONS FROM PUBLIC;

CREATE EVENT TRIGGER auto_grant_trigger
    ON ddl_command_end
    WHEN TAG IN (
            'CREATE SCHEMA',
            'ALTER SCHEMA'
        )
EXECUTE PROCEDURE auto_grant_func();