Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL
Date
Msg-id CAKAnmmL-pEXEreUPfk0khM8be8RDEf2G1MP_QXqgtWOxV25wUg@mail.gmail.com
Whole thread Raw
In response to Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL  (Ayush Vatsa <ayushvatsa1810@gmail.com>)
List pgsql-general
On Tue, Feb 4, 2025 at 1:50 PM Ayush Vatsa <ayushvatsa1810@gmail.com> wrote: 

Also, what would be the best way to ensure that, by default, no roles (except the function owner) have any privileges on new functions created in my protected schema?

Create them in another schema altogether, then move it to my_schema once the privs have been set.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Lookup tables
Next
From: Michał Kłeczek
Date:
Subject: Re: Lookup tables