There is a problem in granting roles. After double clicking a table on the object palette window, it generates the DDL, but the GRANT statement is wrong about ROLE. TOAD generates the GRANT as follows:
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE x.y TO USER ROLE_USR;
But "ROLE_USR" is a ROLE not USER
The right statement should be
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE x.y TO ROLE ROLE_USR;
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for DB2.
ROLE is introduced on DB2 V9.5
