Owen, owner@immuta.com has successfully protected access to credit card transactions utilizing Masking and Row Filtering.
In this final module, we explore how Immuta streamlines work when there are Exceptions, Reporting, and Auditability requirements.
ABC Corp needs to be able to clearly understand how data sources, user attributes, and policies change over time. Also, since Anne will occasionally need to investigate a specific transaction, we will configure immuta to make the credit card number masked, but reversible by Manny.
Does Immuta support all of these scenarios? Let’s find out…
In this module you will:
Login to Immuta as Owen and run a report on who is subscribed to the credit_card_transaction table
While logged in as Owen, view the Audit log and see when the user Anne last queried credit_card_transactions.
While logged in as Owen modify the “Mask-cc-number Global Data Policy” so that masking can be reversible. Login as Anne and submit an unmask request that a particular value be unMasked by Owen.
Add a column to the table and view how this is masked by default.
4.0 Login to Immuta as Owen and run a report on who is subscribed to the credit_card_transaction table |
---|
Immuta Reports allow Data Governors to use a natural language builder to instantly create reports that detail user activity across Immuta.
Click select entity and choose the option you would like the report based on from the dropdown menu. Next choose Data Source and select the ‘Public Credit Card Transactions’ data source.
The Report shows the users who are currently subscribed to the data source.
4.1 While logged in as Owen, view the Audit log and see when the user Anne last queried credit_card_transactions. |
---|
Immuta provides access to all of the audit logs via the Audit page.
If we use the filters, we can find the set of records that represent the activity of Manny (manager@immuta.com) against the Public Credit Card Transactions Data Source.
Are there any Failures?
Successful Activity | Failed Activities |
---|---|
Click on the record and you will see the full details:
4.2 While logged in as Owen modify the “Mask-cc-number Global Data Policy” so that masking can be reversible. Login as Anne and submit an unmask request that a particular value be unMasked by Manny. |
---|
Change the Masking Type to “with reversibility”
4.3 Add a column to the table and view how this is masked by default. |
---|
Using the Amazon Redshift Query Editor, Alter the credit card table and add a new column: ( Use the following Alter Table statement)
alter table public.credit_card_transactions add column New_column varchar default 'secret'