setup DDL Group in Redshift database

 setup DDL  Group in Redshift database

1.create group   <group_name>

2.load the DDL Privilege's to group

3.add the users to DDL  group

create schema <schema_name>;

create group  group_<schema>_DDL;

GRANT CREATE ON  database <DB name>  to group group_<schema>_DDL;

GRANT all ON  schema <schema_name>    to group group_<schema>_DDL;