BUG #1222: database owner should have implicit control over public db schema - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1222
Logged by:          radim kolar

Email address:      hsn@netmag.cz

PostgreSQL version: 7.4.1

Operating system:   freebsd

Description:        database owner should have implicit control over public
db schema

Details:

Problem 2

Database owner should have implicit control over public schema
and over all objects in his database as well.

dbmail=> \l
List of databases
Name    |   Owner   | Encoding
------------+-----------+-----------
dbmail     | dbmail    | SQL_ASCII
template0  | pgsql     | SQL_ASCII
template1  | pgsql     | SQL_ASCII
dbmail=> SELECT current_user;
current_user
--------------
dbmail
(1 row)
dbmail=> GRANT CREATE on SCHEMA public to public;
ERROR:  permission denied for schema public
dbmail=>