Viewing DB2 Object Data in the Investigator › View Catalog Objects › Role

Role

A role is a user-defined database entity that groups privileges together. A role can be assigned to a primary authorization ID or can be shared by all users (PUBLIC). The role is available only in a trusted context (which enables the establishment of a trusted relationship between a DB2 database management system and an external entity). By assigning privileges to a role and then using trusted contexts to limit the circumstances in which the role can be used, you can reduce the risk of unauthorized use of privileges.

You can use the Investigator to perform the following tasks:

• List the user-defined roles, from which you can choose a role and can see detailed information.
• View detailed information about each specific role and its schema.
• List the dependent objects for each role.