"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