Any need of GRANT/REVOKE CREATE TABLE | POLICY | ETC - Mailing list pgsql-hackers

From Haribabu Kommi
Subject Any need of GRANT/REVOKE CREATE TABLE | POLICY | ETC
Date
Msg-id CAJrrPGfb3dL0YcsihFGp5NWHV53L2Y88uPnyBX=zX9bS=DrxQA@mail.gmail.com
Whole thread Raw
Responses Re: Any need of GRANT/REVOKE CREATE TABLE | POLICY | ETC  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi All,

During the discussion of supporting multi tenancy with the help of
row level security, because of some problems of executing any
policy that was created by an unprivileged user [1].

To avoid that problem, If we have some kind of new mechanism to
GRANT/REVOKE only CREATE POLICY from all the unprivileged
users by providing other CREATE access to them.

I just want to know is there any other such requirements that if such
option is available, it would be good or not? I don't know whether
this option is possible or not? If any such requirements are present
other than POLICY, i would like to analyze and propose a patch for
the same.

[1] - https://www.postgresql.org/message-id/21902.1455052932%40sss.pgh.pa.us

Regards,
Hari Babu
Fujitsu Australia



pgsql-hackers by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: Multi-tenancy with RLS
Next
From: Masahiko Sawada
Date:
Subject: Adjust recovery test file name