Jessica Richard <rjessil@xxxxxxxxx> writes: > I am trying to drop a user but it complained with the following message: > ERROR: role "joe" cannot be dropped because some objects depend on it > DETAIL: 1 objects in database Jan_test > 1 objects in database Jan > this user does not own any tables in those two databases. Is there any command I can use to check all the dependencies on this user? Try to do the DROP ROLE within those databases. You'll get more detail about owned objects within the current database, but from outside that database the info isn't reachable ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly