Joshua D. Drake wrote:
Notice that user foo is not a super user. Now I log into PostgreSQL and connect to the postgres database (the super users database) as the non privileged user "foo". The user "foo" in theory has *zero* rights here accept that he can connect.
That's not true. The public schema has public UC privs, and always has had. There is nothing surprising (expect possibly to you) here. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq