Postgres Pro
Downloads
Home   >   mailing lists

Re: How to revoke privileged from PostgreSQL's superuser - Mailing list pgsql-admin

From David G. Johnston
Subject Re: How to revoke privileged from PostgreSQL's superuser
Date
Msg-id CAKFQuwa0SyyzaKEtQzBc008HvtR7GVzv4Nd75Qe_OXtAqzgGGA@mail.gmail.com
Whole thread Raw
In response to How to revoke privileged from PostgreSQL's superuser  (bejita0409@yahoo.co.jp)
Responses Re: How to revoke privileged from PostgreSQL's superuser  (Bear Giles <bgiles@coyotesong.com>)
Re: How to revoke privileged from PostgreSQL's superuser  (Bear Giles <bgiles@coyotesong.com>)
Re: How to revoke privileged from PostgreSQL's superuser  (Bruce Momjian <bruce@momjian.us>)
Re: How to revoke privileged from PostgreSQL's superuser  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view
On Monday, August 6, 2018, <bejita0409@yahoo.co.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.
 

pgsql-admin by date:

Previous
From: "Charles Clavadetscher"
Date:
Subject: RE: How to revoke privileged from PostgreSQL's superuser
Next
From: Bear Giles
Date:
Subject: Re: How to revoke privileged from PostgreSQL's superuser