> -----Original Message----- > From: Ertan Küçükoğlu <ertan.kucuko...@1nar.com.tr> > 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 cannot drop from the system. I revoked all permissions from tables, sequences, functions. They do not own any objects.
I found a table named "data" in postres database's public schema. Owner of that table is postgres user. That table do not have any relation with these users that I failed to drop. It is probably a mistakenly created test table. After I drop that table, these users dropped without any error. That is something weird to me. I am almost 100% sure that I did not give any GRANT for these users out of "pars" database. Alessandro's provided scipt did not return that table when I run it on postgres database and postgres.public schema. Anyway, I could clean up my users in the end. Thanks & regards, Ertan
