=?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= writes:
> Using PostgreSQL 9.6.9 on Linux amd64 platform.
> 2018-08-03 23:24:03.901Drop user failed: SQL Error: ERROR: role
> "pars.test" cannot be dropped because some objects depend on it
> AYRINTI: 1 object in database postgres
I see you've resolved
> -Original Message-
> From: Ertan Küçükoğlu
> Sent: Friday, August 3, 2018 11:42 PM
> To: pgsql-gene...@postgresql.org
> Subject: Eror while dropping a user
>
> Hello,
>
> Using PostgreSQL 9.6.9 on Linux amd64 platform.
>
> I have two users that I canno
> From: Alessandro Aste
> Sent: Saturday, August 4, 2018 12:02 AM
> To: Ertan Küçükoğlu
> Cc: pgsql-gene...@postgresql.org
> Subject: Re: Eror while dropping a user
>
> You can run this query to itendify the relations owned by the users you're
> not all
You can run this query to itendify the relations owned by the users you're
not allowed to drop, just replace ('',
'username2' ..'userN' ) with the your role names . Then, once you have
identified the tables/objecst change the owner like this:
ALTER TABLE OWNER TO ;
and try to drop the use
Hello,
Using PostgreSQL 9.6.9 on Linux amd64 platform.
I have two users that I cannot drop from the system. I revoked all
permissions from tables, sequences, functions. They do not own any objects.
My log lines are as following:
2018-08-03 23:24:03.897There are 2 users that needs to be remove
