Search Postgresql Archives

Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Feb 4, 2025 at 1:50 PM Ayush Vatsa <ayushvatsa1810@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux