Business problem


Data security is becoming one of the biggest challenges for J.K.Avro superstore. One of the company's primary concerns is to prevent misuse of privileges by different users.

Operation


To be compliant with the PCI requirement "Protect stored data" J.K Avro superstore needs to restrict access to the 'credit_card' table. This table holds sensitive information such as card holder name, credit card number, and CCV number.

Solution


To protect and easily maintain access to 'credit_card' table data, J.K.Avro superstore implements DB2 security feature ROLE.

This tutorial demonstrates how DB2 roles address the above problem. Topics presented are:


Click here to refer to Usage Scenario and pre-requisites to prepare this tutorial