Re: How to revoke privileged from PostgreSQL's superuser

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "bejita0409(at)yahoo(dot)co(dot)jp" <bejita0409(at)yahoo(dot)co(dot)jp>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to revoke privileged from PostgreSQL's superuser
Date: 2018-08-06 13:19:55
Message-ID: CAKFQuwa0SyyzaKEtQzBc008HvtR7GVzv4Nd75Qe_OXtAqzgGGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Monday, August 6, 2018, <bejita0409(at)yahoo(dot)co(dot)jp> wrote:

>
> I have a request for revoking the access to user's data from DBA-user.
> I think the request is right because users should be the only ones can
> access their data.
>

User then needs to encrypt data prior to storing it. Superuser can still
access the data but would be challenged to make sense of it,

Usually DBAs are tasked with backups which requires read access to all
relevant data.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bear Giles 2018-08-06 13:22:54 Re: How to revoke privileged from PostgreSQL's superuser
Previous Message Charles Clavadetscher 2018-08-06 10:33:02 RE: How to revoke privileged from PostgreSQL's superuser

Browse pgsql-general by date

  From Date Subject
Next Message Bear Giles 2018-08-06 13:22:54 Re: How to revoke privileged from PostgreSQL's superuser
Previous Message Charles Clavadetscher 2018-08-06 10:33:02 RE: How to revoke privileged from PostgreSQL's superuser