Re: Permission for not Django app to do Write and Read

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Peter Wainaina <petwah17(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Permission for not Django app to do Write and Read
Date: 2019-08-24 09:45:48
Message-ID: CAKoxK+6nPOCeuZxBFCTGk+SF52bM+YhZoFj-Hi=GpnjbEDzX-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Wed, Aug 21, 2019 at 8:26 PM Peter Wainaina <petwah17(at)gmail(dot)com> wrote:
>
> I am managing some development and I need to give Write and Read to only Django .Postgresql administratior can’t write on the same data.How can I configure that from postgresql side.

You should better explain what you are trying to achieve.
I suspect what you need is to create an user to use frm your django
application, then GRANT to such user the ALL permission on the
objects/tables you need.
Or assign such user as the owner of all the objects.

Luca

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Luca Ferrari 2019-08-24 09:52:11 Re: Postgres PITR: Recovery does not seem to fetch from Archive Dir
Previous Message Georg H. 2019-08-23 21:00:10 Re: Question on pgwatch

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2019-08-24 10:00:34 Re: timestamp out of range while casting return value to function's return type
Previous Message PegoraroF10 2019-08-24 09:12:02 Re: slow queries on system tables