On Wed, Nov 2, 2016 at 10:46 PM, Sounak Chakraborty <soun...@gmail.com> wrote:
> Row level security feature implementation in Postgres is through policy and 
> the row security qualifier is attached as a subquery to the main query before 
> query planning. The RLS is implemented through ALTER TABLE STATEMENT.
> But my doubt is why this feature is not enabled in case of Foreign Table. 
> (ALTER FOREIGN TABLE doesn't have a option of enabling Row Level Security).
> Is this is not implemented due to some limitations in the current design?
> Because from a quick view it looks like the security subquery can also be 
> easily attached to the main query and passed for processing in foreign 
> database.

Yeah, I don't see why that couldn't be made to work.

Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to