=?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@xxxxxxxxxxx> writes: > Using PostgreSQL 9.6.9 on Linux amd64 platform. > 2018-08-03 23:24:03.901 Drop 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 your problem, but for future reference, note that you could have gotten a more detailed error message if you'd issued the DROP USER while connected to the postgres database. When the command is issued in database A, we can't see the details of what the user owns in database B, only that there is something over there :-( FWIW, I'm guessing that the issue was not object ownership per se, but permissions granted on some object owned by someone else. Those have to be revoked as well before a DROP USER will succeed. You might also care to read up on DROP OWNED BY. regards, tom lane
