Postgres Pro
Downloads
Home   >   mailing lists

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

From bejita0409@yahoo.co.jp
Subject How to revoke privileged from PostgreSQL's superuser
Date
Msg-id 913907.28546.qm@web103014.mail.kks.yahoo.co.jp
Whole thread Raw
Responses Re: [External] How to revoke privileged from PostgreSQL's superuser  (Vijaykumar Jain <vjain@opentable.com>)
Re: [External] How to revoke privileged from PostgreSQL's superuser  (Vijaykumar Jain <vjain@opentable.com>)
RE: How to revoke privileged from PostgreSQL's superuser  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
RE: How to revoke privileged from PostgreSQL's superuser  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
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  ("David G. Johnston" <david.g.johnston@gmail.com>)
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  (Tim Cross <theophilusx@gmail.com>)
Re: How to revoke privileged from PostgreSQL's superuser  (Tim Cross <theophilusx@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: legrand legrand
Date:
Subject: Re: PostgreSQL 11 global index
Next
From: Vijaykumar Jain
Date:
Subject: Re: [External] How to revoke privileged from PostgreSQL's superuser