Implementing column-level security
Amazon Redshift supports fine-grained data security with column-level controls. Column-level security can be applied to local tables, views, and materialized views. Applying column-level security allows you to restrict access to personally identifiable information (PII) or payment card information (PCI) to selective personas. For instance, the finance or human resources team can be granted access to sensitive information but you can restrict access from the sales and marketing team.
Getting ready
To complete this recipe, you will need:
- An Amazon Redshift data warehouse deployed in the eu-west-1 AWS region
- Amazon Redshift data warehouse master user credentials
- Access to any SQL interface, such as a SQL client or the Amazon Redshift query editor v2
How to do it…
- In this recipe, we will use the customer table. Using column-level access control, the sales user will be restricted from accessing...
