RLS for superuser

Поиск
Список
Период
Сортировка
От Gaurav Tomar
Тема RLS for superuser
Дата
Msg-id CAByYU3SCUxbA=cepB=L+LYNyQY+bCF+2ONcAjZQBHduiBuk7hA@mail.gmail.com
обсуждение исходный текст
Ответы Re: RLS for superuser  ("MS (direkt)" <martin.stoecker@stb-datenservice.de>)
Re: RLS for superuser  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-sql
Hi All,

We are developing an application which will connect to the PostgreSQL 9.5 at backend.
We do not want any DB role/user including superuser to access the table data from the backend, only if the user is logging in from the application can see the data.

To achieve this we have created policies and enable RLS on the tables. By enabling the RLS and creating policies we are able to restrict all the DB user/role including table owner of the table but not able to restrict superuser. 

Regards,

Gaurav

+91 876 265 4621

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Fwd: Regarding change in the size of database
Следующее
От: "MS (direkt)"
Дата:
Сообщение: Re: RLS for superuser