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

čt 11. 6. 2020 v 9:51 odesílatel Laura Smith <
n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch> napsal:

>
>
>
> Sent with ProtonMail <https://protonmail.com> Secure Email.
>
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> On Thursday, 11 June 2020 08:39, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>
> Hi
>
> čt 11. 6. 2020 v 9:29 odesílatel Laura Smith <
> n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch> 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