-- Name: grants_users(); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION grants_users() RETURNS SETOF text

    LANGUAGE sql IMMUTABLE

    AS $$

VALUES ('bien_read'), ('public_')

$$;

--

-- Name: show_grants_for(regclass); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION show_grants_for(table_ regclass) RETURNS text

    LANGUAGE sql STABLE

    AS $_$

SELECT concat(cmd)

FROM

(

	SELECT (CASE WHEN has_table_privilege(user_, $1, 'SELECT') THEN

$$GRANT SELECT ON TABLE $$||$1||$$ TO $$||quote_ident(user_)||$$;

$$ ELSE '' END) AS cmd

	FROM util.grants_users() f (user_)

) s

$_$;

--