How to revoke privileged from PostgreSQL's superuser

From: bejita0409(at)yahoo(dot)co(dot)jp
To: "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: How to revoke privileged from PostgreSQL's superuser
Date: 2018-08-06 09:48:37
Message-ID: 913907.28546.qm@web103014.mail.kks.yahoo.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hello,
 
I am a newbie DBA.
 
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.
But DBA-user also need full access to the other data? It means that DBA-user also needs to be a superuser.
 
So I conclude the request that how to revoke privileged from superuser in postgres.
 
As my knowledge, the superuser in PostgreSQL bypasses all the permission check.
So that, there is no way to do it in PostgreSQL, is that right?
 
Is there some DBAs are faced with this before?
 
 
Thanks,
--
bejita

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2018-08-06 10:19:11 Re: [External] How to revoke privileged from PostgreSQL's superuser
Previous Message legrand legrand 2018-08-06 09:02:39 Re: PostgreSQL 11 global index

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2018-08-06 10:19:11 Re: [External] How to revoke privileged from PostgreSQL's superuser
Previous Message Andreas Kretschmer 2018-08-06 07:13:39 Re: How to avoid dead rows in tables.