On 11/17/22 17:07, David Gauthier wrote:
psql (11.5, server 11.3) on linux
Someone who had privileges in a lot of tables/schemas/DBs left the
company. I want to drop that role but "rop role xxx" won't let me
because... "xxx cannot be dropped because some objects depend on it".
Is there a w
On 18 November 2022 01:14:37 CET, Ron wrote:
>On 11/17/22 17:57, Tom Lane wrote:
>> Ron writes:
>>> On 11/17/22 17:16, Tom Lane wrote:
Not directly, but see REASSIGN OWNED and DROP OWNED.
>>> SIMULATE and VERBOSE options would be handy, to see what those commands
>>> would actually do.
>> Hm
On 11/17/22 17:57, Tom Lane wrote:
Ron writes:
On 11/17/22 17:16, Tom Lane wrote:
Not directly, but see REASSIGN OWNED and DROP OWNED.
SIMULATE and VERBOSE options would be handy, to see what those commands
would actually do.
Hmph. I'm surprised to realize that those commands don't produce
Ron writes:
> On 11/17/22 17:16, Tom Lane wrote:
>> Not directly, but see REASSIGN OWNED and DROP OWNED.
> SIMULATE and VERBOSE options would be handy, to see what those commands
> would actually do.
Hmph. I'm surprised to realize that those commands don't produce
trace output comparable to DR
On 11/17/22 17:16, Tom Lane wrote:
David Gauthier writes:
Someone who had privileges in a lot of tables/schemas/DBs left the
company. I want to drop that role but "rop role xxx" won't let me
because... "xxx cannot be dropped because some objects depend on it".
Is there a way to just get rid o
David Gauthier writes:
> Someone who had privileges in a lot of tables/schemas/DBs left the
> company. I want to drop that role but "rop role xxx" won't let me
> because... "xxx cannot be dropped because some objects depend on it".
> Is there a way to just get rid of this role without revoking
On 11/17/22 15:07, David Gauthier wrote:
psql (11.5, server 11.3) on linux
Someone who had privileges in a lot of tables/schemas/DBs left the
company. I want to drop that role but "rop role xxx" won't let me
because... "xxx cannot be dropped because some objects depend on it".
Is there a w
psql (11.5, server 11.3) on linux
Someone who had privileges in a lot of tables/schemas/DBs left the
company. I want to drop that role but "rop role xxx" won't let me
because... "xxx cannot be dropped because some objects depend on it".
Is there a way to just get rid of this role without revoki