[pgadmin-support] REVOKE PRIVILEGES in SQL tab of selected function

Let’s say we have this function:

CREATE OR REPLACE FUNCTION public.test(in_value character varying) RETURNS character varying

LANGUAGE 'plpgsql' COST 100.0 VOLATILE LEAKPROOF SECURITY DEFINER

AS $$

BEGIN

    RETURN in_value;

END;

$$;

ALTER FUNCTION public.test(character varying) OWNER TO user_group_1;

REVOKE ALL PRIVILEGES ON FUNCTION public.test(character varying) FROM public;

GRANT EXECUTE ON FUNCTION public.test(character varying) TO user_group_2;

Now let’s see it with pgAdmin 3:

...

GRANT EXECUTE ON FUNCTION public.test(character varying) TO user_group_1;

GRANT EXECUTE ON FUNCTION public.test(character varying) TO user_group_2;

REVOKE ALL ON FUNCTION public.test(character varying) FROM public;

And now with pgAdmin 4:

...

GRANT EXECUTE ON FUNCTION public.test(character varying) TO user_group_1;

GRANT EXECUTE ON FUNCTION public.test(character varying) TO user_group_2;

Like you can see the revoke of public access is not included in pgAdmin 4 in SQL tab.

It would be nice to have the whole list of privileges changes there. Because for example when I copy the code and execute it on another database, then everyone has access to it!

pgAdmin 4 v1.5

Desktop Runtime

Windows 10 x64 1511

PostgreSQL 9.6.3