BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn't work

From: "Richard Rowell" <richard(dot)rowell(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn't work
Date: 2007-08-15 16:29:39
Message-ID: 200708151629.l7FGTdps040132@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3540
Logged by: Richard Rowell
Email address: richard(dot)rowell(at)gmail(dot)com
PostgreSQL version: 8.2
Operating system: Linux
Description: "REVOKE CREATE ON SCHEMA" public doesn't work
Details:

richard(at)meowth:~/download$ createdb perm_test
CREATE DATABASE
richard(at)meowth:~/download$ psql -U postgres perm_test

Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms

\h for help with SQL commands

\? for help with psql commands

\g or terminate with semicolon to execute query

\q to quit

perm_test=> create schema foo;

CREATE SCHEMA

perm_test=# create role bar login;

CREATE ROLE

perm_test=> revoke create on schema foo from bar;

REVOKE

perm_test=# revoke create on schema public from bar;

REVOKE

perm_test=# \q

richard(at)meowth:~/download$ psql -U bar perm_test

Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms

\h for help with SQL commands

\? for help with psql commands

\g or terminate with semicolon to execute query

\q to quit

perm_test=> create table foo.test (uid integer);

ERROR: permission denied for schema foo

perm_test=> create table test (uid integer);
CREATE TABLE

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Leoj 2007-08-15 16:41:56 BUG #3541: typo - minor importance
Previous Message Erik R. 2007-08-15 15:39:24 BUG #3539: tsearch2 broken on Intel Macs running Leopard