Home > mailing lists

permissions PostgreSQL 9.5 - Mailing list pgsql-general

From	Patrick B
Subject	permissions PostgreSQL 9.5
Date	August 10, 2016 01:33:58
Msg-id	CAJNY3it5cgg+4XrX08yg5Q=V2vUkHu_m4yDtYY8EufxuYF2EWg@mail.gmail.com Whole thread Raw
Responses	Re: permissions PostgreSQL 9.5
List	pgsql-general

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?

Thanks

From: Tom Lane
Date: 10 August 2016, 01:06:57
Subject: Re: Detecting if current transaction is modifying the database

From: rob stone
Date: 10 August 2016, 02:09:05
Subject: Re: permissions PostgreSQL 9.5