Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL
Дата
Msg-id CAKAnmmL-pEXEreUPfk0khM8be8RDEf2G1MP_QXqgtWOxV25wUg@mail.gmail.com
обсуждение исходный текст
Ответ на Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL  (Ayush Vatsa <ayushvatsa1810@gmail.com>)
Список 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 по дате отправления: