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.
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: