I am using version 16.6.10 and trying to get table DDL to include a grant to a group. I have a second PDM using Oracle that generates a grant to a role. The Oracle DDL generation includes the grant but Redshift DDL does not. I believe that I have set all the options the same (where applicable). What am I missing.
I would also like to generate the following:
alter table <table name> owner to <schema Name>;
I tried using the End Script but this did not work.