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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jim Seymour
Sent: Tuesday, June 08, 2004 5:06 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Prevent users from creating tables
"Campano, Troy" <Troy.Campano@LibertyMutual.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@postgresql.org so that your
message can get through to the mailing list cleanly