Re: Prevent users from creating tables

I tried this out, however none of this seems to prevent a user from
creating tables. It can prevent users from viewing or modifying data on
existing tables, but I can't find a solution where I can prevent users
from creating tables.

Any ideas?

Thank you!

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Jim Seymour
Sent: Tuesday, June 08, 2004 5:06 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Prevent users from creating tables

"Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com> wrote:
>
> Hello,
> I'm trying to set up PostgreSQL for proof of concept according to our
> standards.
> I need to create a user for database01 that has the ability to create
> any objects they want.
> They can create tables, views, indexes, etc.
>
> Then I need a second user that has the privileges to only SELECT,
> INSERT, UPDATE, DELETE from objects in a certain database.
>
> How do I grant these privs?
> How do I prevent a user from dropping objects?

http://www.postgresql.org/docs/7.4/static/sql-grant.html

Jim

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly