When executing a Compare Strategy, RC/Migrator is not creating GRANTS where the table and authorizations exist in the source object but not in the target object. If the Compare results in a DROP/CREATE, the GRANTS are generated. If the Compare results in a CREATE on the target, no GRANTS are generated.
Release: R20
Component: RCC
RC/Compare does not perform security migration between source and target. All GRANT statements in the SQL are ignored. It only compares DDL and then reapplies any security that exists on a target system.
See: Compare Strategy Services
2 (Source SQL to target Db2 subsystem) and 3 (Source Db2 subsystem to target SQL)
"Security is not performed on target SQL compares. Therefore, all GRANT statements in the SQL are ignored. Only the DDL is compared; afterwards, any security that exists on the target subsystem is reapplied."