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!
