Re: Possibility to disable `ALTER SYSTEM` - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Possibility to disable `ALTER SYSTEM`
Date
Msg-id 4072160.1710887727@sss.pgh.pa.us
Whole thread Raw
In response to Re: Possibility to disable `ALTER SYSTEM`  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On Tue, Mar 19, 2024 at 2:28 PM Magnus Hagander <magnus@hagander.net> wrote:
>> Windows has had full ACL support since 1993. The  easiest way to do
>> what you're doing here is to just set a DENY permission on the
>> postgres operating system user.

> Yeah. See <
> https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/icacls>
> for example.

Cool.  Maybe somebody should take a fresh look at the places where
we're assuming Windows has nothing comparable to Unix permissions
(for example, checking for world readability of ssl_key_file).
It's off-topic for this thread though.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Kartyshov Ivan
Date:
Subject: Re: [HACKERS] make async slave to wait for lsn to be replayed
Next
From: "Amonson, Paul D"
Date:
Subject: RE: Popcount optimization using AVX512