Обсуждение: Re: Make bloom extension trusted, but can not drop with normal user

Поиск
Список
Период
Сортировка

Re: Make bloom extension trusted, but can not drop with normal user

От
Mladen Gogala
Дата:
Why do you think that the normal user should be allowed to drop 
extensions? Extensions are additions to the RDBMS functionality. Do you 
really want normal users to tinker with the database functionality and 
reduce the number of index types you can create? I am not sure that I am 
on board with that idea.

Regards

On 8/20/21 7:01 AM, Li EF Zhang wrote:
> So, I want to know if extensions in contrib dir can be set "trusted" 
> ourselves? If we can, I think drop extension should be allowed by 
> normal user.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

Re: Make bloom extension trusted, but can not drop with normal user

От
"David G. Johnston"
Дата:
On Sat, Aug 21, 2021 at 1:09 PM Mladen Gogala <gogala.mladen@gmail.com> wrote:
Why do you think that the normal user should be allowed to drop
extensions?

The documentation.

https://www.postgresql.org/docs/current/sql-createextension.html

"This configuration gives the calling user the right to drop the extension, but not to modify individual objects within it."

David J.