Create and grant roles



You must log into the database as Pat before proceeding with this page.

A database role is essentially a database object that groups together one or more privileges or database authorities. Roles can be granted to users, groups, PUBLIC, trusted context, and other roles.

Data in the 'credit_card' table is accessible to all employees of J.K.Avro superstore. To protect access to sensitive information and provide ease of access management, J.K.Avrosuper store implements DB2 roles.

Operation


Pat, the SECADM, creates and grants roles to users as defined below.


Solution


The commands in the right pane show that Pat creates roles and grants them to users Joe and Bob.