> > 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. >
Is it safe to remove UC privs on the public schema? Having rights to "connect" should mean connect, not connect and create. Jon Jon ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
