From: | "Joel Burton" <joel(at)joelburton(dot)com> |
---|---|
To: | "M(dot)L(dot)Bowman" <M(dot)L(dot)Bowman(at)ukc(dot)ac(dot)uk>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: deny table creation |
Date: | 2002-06-10 15:15:47 |
Message-ID: | 004f01c21091$b2eb69b0$63eebed1@jburtonsat3005 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Control over table creation (in a database or in a particular schema) will
be in 7.3 (now in CVS) via traditional GRANT/REVOKE statements.
AFAIK, there's no way to prevent it in PG ver < 7.3.
- J.
--
Joel BURTON | joel(at)joelburton | www.joelburton.com | aim:wjoelburton
Information Technology & Knowledge Management Consultant
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of M.L.Bowman
> Sent: Friday, June 07, 2002 12:47 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] deny table creation
>
>
> 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
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-06-10 15:42:53 | Re: Help with data transfer please |
Previous Message | Bruno Wolff III | 2002-06-10 15:15:28 | Re: deny table creation |