369721 – PostgreSQL Server grants the create permission to public on the schema public

Bug 369721 - PostgreSQL Server grants the create permission to public on the schema public

Summary: PostgreSQL Server grants the create permission to public on the schema public

Status:	RESOLVED INVALID

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	[OLD] Server (show other bugs)
Hardware:	All Linux

Importance:	Normal normal (vote)
Assignee:	Gentoo Linux bug wranglers

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2011-06-02 01:31 UTC by David van Laatum
Modified:	2011-06-03 11:37 UTC (History)
CC List:	0 users

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description David van Laatum 2011-06-02 01:31:20 UTC

Using 9.0.3 it appears that by default the public group (ie everyone) in postgreSQL has create permission on the public schema of all databases. I assume the permission is set incorrectly on the template1 table. This also appears to be happening in debian lenny installs at my work.

Reproducible: Always

Comment 1 Aaron W. Swenson gentoo-dev

2011-06-03 11:37:48 UTC

http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PRIV

We follow upstream here.