DB2: Roles Cheat Sheet

Creating and granting membership in roles

db2 create role <role_name> 

Granting role from DBADM to a particular table

db2 grant select on table <table_name> to role <role_name> 

Add users to a role

db2 grant role <role_name> to user <username> 

Role hierarchies

db2 grant role <roll_name> to role <role_name>

Leave a Reply

Your email address will not be published. Required fields are marked *