Other: HVR - ADAPTDDL
AnsweredWhen switching on ADAPTDDL on HVR channels, permissions on the target table get lost if the table has to be dropped and recreated. There is limited functionality built in to accomodate Postgres databases, using DbObjectGeneration with SELECT_TO_PUBLIC.
However, for Oracle targets it doesn't seem possible. Can the options of DbObjectGeneration be expanded to include Custom GRANT statements so that permissions can automatically be put back post Drop/Recreate table as part of AdaptDDL?
-
Hi Stephen,
Thank you for this request. We will study if this is possible and feasible and come back with our findings.
Best regards,
Edwin
Please sign in to leave a comment.
Comments
1 comment