From: | "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com> |
---|---|
To: | "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org> |
Subject: | Prevent users from creating tables |
Date: | 2004-06-08 19:19:38 |
Message-ID: | 82C3FD729CFA504CA44E7D32BDED411F0A2EFC6F@lm-exmsg-07.lm.lmig.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Thank you!
Troy Campano
Liberty Mutual
Infrastructure Software Engineering
Database Management
desk: (603) 245 4092
cell: (603) 219 5539
Department Information
<http://intranet.lmig.com:3000/infosys/infra/software/database/dbapp/dep
artment/index.jsp>
From | Date | Subject | |
---|---|---|---|
Next Message | Shachar Shemesh | 2004-06-08 20:21:29 | Re: Windows Library for libpq |
Previous Message | Scot L. Harris | 2004-06-08 19:04:46 | Re: Multiple databases on seperate drives/file systems? |