Re: Security definer function to alter a sequence

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Security definer function to alter a sequence
Date: 2025-02-11 22:57:14
Message-ID: 60f17e57-2549-442a-a11d-5e9ec63bd4eb@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)quadratum-braccas(dot)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.
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message srinivasan s 2025-02-12 04:44:53 Table size is constantly growing and causing performance problems
Previous Message David G. Johnston 2025-02-11 21:57:26 Re: Security definer function to alter a sequence