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

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 (view raw or flat)
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

pgsql-bugs by date

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

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