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

Laura Smith wrote: > ‐‐‐ Original Message ‐‐‐ > On Thursday, 11 June 2020 08:39, Pavel Stehule > wrote: > > > Hi > > > > čt 11. 6. 2020 v 9:29 odesílatel Laura Smith > > napsal: > > > > > Hi, > > > > > > Just curious if there is a way to switch a function from definer to > > >

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

čt 11. 6. 2020 v 9:51 odesílatel Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> napsal: > > > > Sent with ProtonMail Secure Email. > > ‐‐‐ Original Message ‐‐‐ > On Thursday, 11 June 2020 08:39, Pavel Stehule > wrote: > > Hi > > čt 11. 6. 2020 v 9:29

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

Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Thursday, 11 June 2020 08:39, Pavel Stehule wrote: > Hi > > čt 11. 6. 2020 v 9:29 odesílatel Laura Smith > napsal: > > > Hi, > > > > Just curious if there is a way to switch a function from definer to invoker > >

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

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

Changing from security definer to security invoker without dropping ?

Hi, Just curious if there is a way to switch a function from definer to invoker without dropping ? We're working on improving the security posture by changing functions from definer to invoker, but I'm wondering what the best way to roll this out to production is given that dropping and