Postgres Pro
Downloads
Home   >   mailing lists

Changing from security definer to security invoker without dropping ? - Mailing list pgsql-general

From Laura Smith
Subject Changing from security definer to security invoker without dropping ?
Date
Msg-id JjNNVyex4-kOUrDx5hV-MXEgWxlT7cYmCN8DheQuJGPsA0p24kkqVGMUoqrNIDa1b5Zo2uC9LCvtmX_NWg23NmGIa3bJyga6lJTJ6gCnSOM=@protonmail.ch
Whole thread Raw
Responses Re: Changing from security definer to security invoker withoutdropping ?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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
thebest way to roll this out to production is given that dropping and re-creating functions could potentially cause
upstreamclient hassles ? 

Laura

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Parallel safety of contrib extensions
Next
From: Pavel Stehule
Date:
Subject: Re: Changing from security definer to security invoker withoutdropping ?