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
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? |