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
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?