How to revoke privileged from PostgreSQL's superuser

Поиск

Список

Период

Сортировка

От	bejita0409@yahoo.co.jp
Тема	How to revoke privileged from PostgreSQL's superuser
Дата	6 августа 2018 г. 15:48:37
Msg-id	913907.28546.qm@web103014.mail.kks.yahoo.co.jp обсуждение исходный текст
Ответы	Re: [External] How to revoke privileged from PostgreSQL's superuser Re: [External] How to revoke privileged from PostgreSQL's superuser RE: How to revoke privileged from PostgreSQL's superuser RE: How to revoke privileged from PostgreSQL's superuser Re: How to revoke privileged from PostgreSQL's superuser Re: How to revoke privileged from PostgreSQL's superuser Re: How to revoke privileged from PostgreSQL's superuser Re: How to revoke privileged from PostgreSQL's superuser Re: How to revoke privileged from PostgreSQL's superuser Re: How to revoke privileged from PostgreSQL's superuser
Список	pgsql-admin

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 по дате отправления:

От: legrand legrand
Дата: 06 августа 2018 г., 15:02:39
Сообщение: Re: PostgreSQL 11 global index

От: Vijaykumar Jain
Дата: 06 августа 2018 г., 16:19:11
Сообщение: Re: [External] How to revoke privileged from PostgreSQL's superuser