Re: [GENERAL] permissions PostgreSQL 9.5

2016-08-09 Thread rob stone
On Wed, 2016-08-10 at 13:33 +1200, Patrick B wrote: > hi guys, > > > just setting up a new DB using PostgreSQL 9.5. > > > I've created a new username for the code, called codeuser. > > To give the username access to all the tables, views, etc I ran: > > > GRANT INSERT, SELECT, UPDATE, DELETE

[GENERAL] permissions PostgreSQL 9.5

2016-08-09 Thread Patrick B
hi guys, just setting up a new DB using PostgreSQL 9.5. I've created a new username for the code, called codeuser. To give the username access to all the tables, views, etc I ran: GRANT INSERT, SELECT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO > codeuser; Is that ok? Is that enough?