RC/Compare for DB2 for Z/OS : DB2 Object Compare not creating GRANTS or moving authorizations.

Products

• RC Compare for DB2 for z/OS

Issue/Introduction

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.

 

Environment

Release: R20
Component: RCC

Resolution

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."

Additional Information

Compare Strategy Services