> From: Alessandro Aste <alessandro.aste@xxxxxxxxx> > Sent: Saturday, August 4, 2018 12:02 AM > To: Ertan Küçükoğlu <ertan.kucukoglu@xxxxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Eror while dropping a user > > You can run this query to itendify the relations owned by the users you're not allowed to drop, > just replace ('<your_user_name_to_check>', 'username2' ..'userN' ) with the your role names . > Then, once you have identified the tables/objecst change the owner like this: I tried to run it on "postgres" database and "pars" database, schemas on pars database, etc. All return empty results. Thanks anyway. Regards, Ertan