Re: How to revoke privileged from PostgreSQL's superuser

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: How to revoke privileged from PostgreSQL's superuser
Дата
Msg-id 20180810194105.GD7840@momjian.us
обсуждение исходный текст
Ответ на Re: How to revoke privileged from PostgreSQL's superuser  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: How to revoke privileged from PostgreSQL's superuser  (Benedict Holland <benedict.m.holland@gmail.com>)
Re: How to revoke privileged from PostgreSQL's superuser  (Benedict Holland <benedict.m.holland@gmail.com>)
Список pgsql-admin
On Mon, Aug  6, 2018 at 06:19:55AM -0700, David G. Johnston wrote:
> 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,

Keep in mind DBAs can often remove data with little detection, unless
you are using some kind of block chain, which itself can force
serialized data access, slowing things down.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Upgrade postgresql from 9.1 to 9.6
Следующее
От: Benedict Holland
Дата:
Сообщение: Re: How to revoke privileged from PostgreSQL's superuser