Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rbi8a-00Gd19-10 for pgsql-general@arkaria.postgresql.org; Sun, 18 Feb 2024 14:27:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rbi8Y-00A3ks-5O for pgsql-general@arkaria.postgresql.org; Sun, 18 Feb 2024 14:27:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rbi8X-00A3kk-Mb for pgsql-general@lists.postgresql.org; Sun, 18 Feb 2024 14:27:21 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rbi8P-007NIw-Ia for pgsql-general@lists.postgresql.org; Sun, 18 Feb 2024 14:27:20 +0000 Received: from [192.168.0.104] (unknown [62.217.189.115]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: p.luzanov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 21E42E20E2E; Sun, 18 Feb 2024 17:27:10 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1708266430; bh=/4yFNEtwIYJ5SeTVV0N0sn5SYbx7U6y2GzWBmlseTvQ=; h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From: In-Reply-To:From; b=cx2lyj+sTYMtPbJNSRLgT1IWNWFwnhoNHVQRWkHYnhmY+jFhkDr3xDd3pJqLIfD3e HpmrtZTbB+TsoPvRRmWwlk6arT/CgND2OdvEDL7m/W/VHxOb47x/c96BgUiEvYAPru mqxiM5YGOnUAvuXIehoKqm7LUy3mirZMf55MYqccfCp9wZXUwKxThUsZ1/xXhRC7Pg TxRrSZv6HCJZro0iC0XLul2MST0NrNXjUTu46izlkwfJC9YO4DKgELL5SJkvnrSVb7 2AR69/eop4m/4X37GBT4vPdy/ydQubMct8uoEEpepE5IuLAKFOQLYIXXj5O34RBXjl 6LwCI6xEpLxfQ== Content-Type: multipart/alternative; boundary="------------H7Qy0TvRJGZMYekuWyXvfYxs" Message-ID: <459ef527-5d83-4bed-90d5-4bbabc1da91c@postgrespro.ru> Date: Sun, 18 Feb 2024 17:27:09 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Users and object privileges maintenance Content-Language: en-US, ru-RU To: Dominique Devienne , Laurenz Albe Cc: Lok P , pgsql-general References: From: Pavel Luzanov In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------H7Qy0TvRJGZMYekuWyXvfYxs Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 18.02.2024 15:19, Dominique Devienne wrote: > On Sun, Feb 18, 2024 at 12:30 PM Laurenz Albe > wrote: > > 2. In PostgreSQL, there is the important concept of ownership, > which is not tied to the schema. >    The owner is the user who created the object. > > > Personally I find that confusing. I wouldn't mind schema objects all > belonging to the one owner. > Or being to enforce that, as an opt-in option. Not sure what's the > benefits of different owners for a schemas objects are. The situation is even more confusing :-) Roles with membership in object owner role acts as an owner. For example they can modify or drop object or grant/revoke access to object. -- Pavel Luzanov Postgres Professional:https://postgrespro.com --------------H7Qy0TvRJGZMYekuWyXvfYxs Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 18.02.2024 15:19, Dominique Devienne wrote:
On Sun, Feb 18, 2024 at 12:30 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
 
2. In PostgreSQL, there is the important concept of ownership, which is not tied to the schema.
   The owner is the user who created the object.

Personally I find that confusing. I wouldn't mind schema objects all belonging to the one owner.
Or being to enforce that, as an opt-in option. Not sure what's the benefits of different owners for a schemas objects are.
The situation is even more confusing :-)
Roles with membership in object owner role acts as an owner.
For example they can modify or drop object or grant/revoke access to object.
-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com
--------------H7Qy0TvRJGZMYekuWyXvfYxs--