Bug#571135: postgresql-8.4 - public have CREATE rights in public schema

2011-10-15 Thread Christoph Berg
Re: Bastian Blank 2011-10-15 <20111015184537.ga10...@wavehammer.waldi.eu.org> > On Sat, Oct 15, 2011 at 08:04:35PM +0200, Christoph Berg wrote: > > I don't think this is going to be changed. The initial permissions are > > there to make the database usable for "the public" (that's also what > > the

Bug#571135: postgresql-8.4 - public have CREATE rights in public schema

2011-10-15 Thread Bastian Blank
On Sat, Oct 15, 2011 at 08:04:35PM +0200, Christoph Berg wrote: > I don't think this is going to be changed. The initial permissions are > there to make the database usable for "the public" (that's also what > the name says). If you don't like the public schema, just drop it. This is not possible.

Bug#571135: postgresql-8.4 - public have CREATE rights in public schema

2011-10-15 Thread Christoph Berg
severity 571135 normal thanks Re: Bastian Blank 2010-02-23 <20100223185637.ga7...@wavehammer.waldi.eu.org> > By default, public have USAGE rights to template1, so can always connect > there if allowed by pg_hba.conf. Now the default permissions of the > public schema are CREATE and USAGE for publi

Bug#571135: postgresql-8.4 - public have CREATE rights in public schema

2010-02-23 Thread Bastian Blank
Package: postgresql-8.4 Version: 8.4.2-2 Severity: important Tags: security By default, public have USAGE rights to template1, so can always connect there if allowed by pg_hba.conf. Now the default permissions of the public schema are CREATE and USAGE for public. This means that everyone is allowe