Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Ayush Vatsa <ayushvatsa1810(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL
Date: 2025-02-04 21:47:02
Message-ID: CAKAnmmL-pEXEreUPfk0khM8be8RDEf2G1MP_QXqgtWOxV25wUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 4, 2025 at 1:50 PM Ayush Vatsa <ayushvatsa1810(at)gmail(dot)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

>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michał Kłeczek 2025-02-05 05:44:49 Re: Lookup tables
Previous Message Karsten Hilbert 2025-02-04 21:44:19 Re: Lookup tables