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