Skip site navigation (1) Skip section navigation (2)

BUG #1222: database owner should have implicit control over public db schema

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1222: database owner should have implicit control over public db schema
Date: 2004-08-17 18:43:13
Message-ID: 20040817184313.96D365A118B@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1222
Logged by:          radim kolar

Email address:      hsn(at)netmag(dot)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=>



Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-08-17 18:59:39
Subject: Re: BUG #1221: revoke on schema do not return error on failure
Previous:From: PostgreSQL Bugs ListDate: 2004-08-17 18:40:40
Subject: BUG #1221: revoke on schema do not return error on failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group