Prevent users from creating tables

[Campano, Troy]

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: [phone]
cell: [phone]
Department Information
<http://intranet.lmig.com:3000/infosy...base/dbapp/dep
artment/index.jsp>

[Jim Seymour]

"Campano, Troy" <Tr**********@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/s...sql-grant.html

Jim

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

[Jim Seymour]

"Campano, Troy" <Tr**********@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/s...sql-grant.html

Jim

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