REVOKE PRIVILEGES in SQL tab of selected function

From: <mammoth(dot)power(at)gmx(dot)us>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: REVOKE PRIVILEGES in SQL tab of selected function
Date: 2017-06-16 07:35:49
Message-ID: 009b01d2e673$2d784550$8868cff0$@gmx.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Stephen Frost 2017-06-16 13:00:33 Re: Migrating this list to PGLister on Friday, June 16th, 1300 UTC
Previous Message Richard Greenwood 2017-06-16 01:30:05 Re: So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?