Posted On: Nov 29, 2023

Amazon Redshift now supports CONJUNCTION TYPE support for you row-level security (RLS) policies and RLS support on standard views and late binding views, which enables you to apply granular access controls and ensure that users only can access rows that they are authorized to see, even when the underlying data evolves or user permissions change.ENnbsp;

RLS support on standard views and late binding views applies to both local and remote data, and RLS support on late binding views now encompasses granular access control for objects received through data sharing and those that reference external data. For instance, as a consumer in data sharing, you have the ability to construct late binding views atop the tables shared with you and attach RLS policies to these views. Similarly, you can establish late binding views on external tables and attach RLS policies for them. Consequently, when your users execute queries on these late binding views, they will only see the subset of data they are authorized to view. CONJUNCTION TYPE allows you to combine multiple RLS policies with either AND or OR operation at table level, you can configure CONJUNCTION TYPE with ALTER TABLE command.ENnbsp;

CONJUNCTION TYPE support for RLS policies and RLS support on standard views and late binding views is available in all commercial and AWS GovCloud (US) Regions where Amazon Redshift is available. To learn more, visit the Amazon Redshift database developer guide.