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 selected people. For instance, you can grant the finance or human resources team access to sensitive information but restrict access to the sales and marketing team.
Getting ready
To complete this recipe, you will need the following:
- An Amazon Redshift cluster deployed in AWS Region
eu-west-1 - Amazon Redshift cluster masteruser credentials
- Access to any SQL interface such as a SQL client or the Amazon Redshift Query Editor
How to do it
In this recipe, we will use a customer table. Using column-level access control, a sales user will be restricted from accessing the phone number column:
- Connect to the Amazon Redshift cluster...
