Re: Changing from security definer to security invoker without dropping ?

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

čt 11. 6. 2020 v 9:51 odesílatel Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx> napsal:

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Thursday, 11 June 2020 08:39, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:

Hi

čt 11. 6. 2020 v 9:29 odesílatel Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx> napsal:

Hi,

Just curious if there is a way to switch a function from definer to invoker without dropping ?

create function foo(a int) returns int as $$ begin return $1; end $$ language plpgsql;

postgres=# alter function foo (int) security definer;

ALTER FUNCTION

postgres=# alter function foo (int) security invoker;

ALTER FUNCTION

regards

Pavel

Thanks Pavel !  Didn't realise it was that easy.

It is postgres - things are easy (almost time) or impossible :)

Pavel