Thread: Re: Make bloom extension trusted, but can not drop with normal user
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
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.
"This configuration gives the calling user the right to drop the extension, but not to modify individual objects within it."
David J.