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
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 |