Postgres Pro
Downloads
Home   >   mailing lists

Re: Security definer function to alter a sequence - Mailing list pgsql-admin

From Sbob
Subject Re: Security definer function to alter a sequence
Date
Msg-id 60f17e57-2549-442a-a11d-5e9ec63bd4eb@quadratum-braccas.com
Whole thread Raw
In response to Re: Security definer function to alter a sequence  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Security definer function to alter a sequence
List pgsql-admin
Tree view

I thought that DDL calls in a security definer function were blocked. I may be confused



On 2/11/25 2:57 PM, David G. Johnston wrote:
On Tue, Feb 11, 2025 at 2:53 PM Sbob <sbob@quadratum-braccas.com> wrote:

Can I create a security definer function to alter a sequence value? Or
is this considered DDL (and thus a security definer function os not
allowed to run it)?


What makes you think it being DDL makes any difference?

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Security definer function to alter a sequence
Next
From: srinivasan s
Date:
Subject: Table size is constantly growing and causing performance problems