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

Поиск
Список
Период
Сортировка
От Laura Smith
Тема Re: Changing from security definer to security invoker without dropping ?
Дата
Msg-id PbdhttIUMTxHPxoJrd2ceE9iOxIOSptIK0tLo_9KcZQZiJeyoPW5_uFz794Kh56vEt1h9CPIk66FLdj0HiZIN8REzWfGoqeE42gZbO_ecCU=@protonmail.ch
обсуждение исходный текст
Ответ на Re: Changing from security definer to security invoker withoutdropping ?  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Changing from security definer to security invoker withoutdropping ?
Re: Changing from security definer to security invoker withoutdropping ?
Список pgsql-general
Дерево обсуждения 


Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, 11 June 2020 08:39, Pavel Stehule <pavel.stehule@gmail.com> wrote:

> Hi
>
> čt 11. 6. 2020 v 9:29 odesílatel Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.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.

В списке pgsql-general по дате отправления: