"Madeleine Theile" <mt@xxxxxxxxxx> writes: > But what if he doesn't? Then the only possibility is to drop all the > views and recreate them as another user in order to fix the issue with > the acl rights. See ALTER OWNER. The intention is to make you give away all the owned objects before getting rid of the user. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster