deny table creation

From: "M(dot)L(dot)Bowman" <M(dot)L(dot)Bowman(at)ukc(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: deny table creation
Date: 2002-06-07 16:47:21
Message-ID: E17GMtV-0000h7-00@myrtle.ukc.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am trying to deny the ability to create tables in a database to
all users except the database owner and the superuser.

As superuser, I have attempted to revoke insert/update/delete/rules
permissions to users on pg_class and pg_tables, but to no avail. It
would appear that the read/insert/update permissions on these two
relations are fixed. Users are always able to create tables. Yet when
I try to display the permissions I get

\z pg_class
Access privileges for database "cswdb"
Table | Access privileges
-------+-------------------
(0 rows)

\z pg_tables
Access privileges for database "cswdb"
Table | Access privileges
-------+-------------------
(0 rows)

Is it the superuser who is updating these tables via Rules rather
than the current user?

Can any-one suggest an alternative approach to preventing users
from creating tables?

Thanks
Maggie Bowman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Snyder 2002-06-07 17:27:08 Re: Slow connection
Previous Message Stephan Szabo 2002-06-07 16:41:06 Re: Problem with indexes, LIMIT, ORDER BY ... DESC