Re: Prevent users from creating tables

From: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Prevent users from creating tables
Date: 2004-06-09 12:45:27
Message-ID: 82C3FD729CFA504CA44E7D32BDED411F0A2EFCF0@lm-exmsg-07.lm.lmig.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober 2004-06-09 13:05:47 Re: Prevent users from creating tables
Previous Message Richard Huxton 2004-06-09 12:08:43 Re: pg_dumpall and large objects