Search Postgresql Archives

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

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

 



On Fri, Aug 20, 2021 at 6:26 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Li EF Zhang" <bjzhangl@xxxxxxxxxx> writes:
> Since pg13 support trusted extension, so I changed control file of bloom and make it trusted.

The fact that you can edit the file that way doesn't make it a supported
case.


Why does that matter here though?  This isn't a question about a security violation, it's one about the basic premise that a trusted extension is owned by the creating user and thus can be dropped by them.  During installation, a trusted user is permitted to perform superuser actions by virtue of the trusted flag.  Since they are allowed to drop their own extension it is at least plausible to assume that upon doing so the dropping would be done as a superuser as well.  That this is not the case doesn't seem to be documented nor, going from the commit message for the feature, does it seem intentional.

David J.


[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