Skip to Content
Jul 14, 2020 at 10:34 PM

Generate Permissions using Amazon Redshift


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.