"Campano, Troy" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
