-
Title
Generated DDL is incorrect as it contains keywords for GROUPS instead of ROLES -
Description
In Toad Data Modeler reverse engineering, the roles are interpreted as groups. When generate a DDL from my model, the permissions are set to GRANT X TO GROUP instead of GRANT X TO ROLE. -
Resolution
WORKAROUND
Attached is a package DB2v97Roles.txg. Please follow these steps to implement the package:
1. Place it in c:\Program Files (x86)\Quest Software\Toad Data Modeler 5.1\Packages\User\
2. Start then Restart Toad.
3. Check if the package is loaded in Package Explorer.
a. Export Mode must be enabled. Go to Settings | Options | General | tick Expert Mode.
b. Click Expert Mode | Customization | Package Explorer. Find the package from the list. Note that the icon should be “blue x with green” as seen in the sample screenshot ‘package explorer.jpg’.
4. Disable export mode from settings.
To check that it works, in DB2 9.7 model:
1. Create some UserGroup,
2. Create some Permissions for e.g. a table
3. Check the DDLSTATUS
Waiting for fix in a future release of Toad Data Modeler
-
Defect ID
CR333 -
Attachments
