Re: Users and object privileges maintenance - Mailing list pgsql-general

From Pavel Luzanov
Subject Re: Users and object privileges maintenance
Date
Msg-id 4d9f0928-950c-401d-b2d3-f11faf39a1fb@postgrespro.ru
Whole thread Raw
In response to Re: Users and object privileges maintenance  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Users and object privileges maintenance  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
On 18.02.2024 17:40, Dominique Devienne wrote:
Well, membership in a role mean you can "become that role", no? Thus this seems logical,
and not confusing to me, that you can act as the owner, since you SET ROLE to the owner.
They may acts as the owner even without explicit SET ROLE to the owner.
It wasn't obvious to me when I came to postgres from oracle.
-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Users and object privileges maintenance
Next
From: Adrian Klaver
Date:
Subject: Re: Users and object privileges maintenance