To allow roles to delete talbes in a specific database.schema:
grant DELETE TABLE on <dbName>.<schmeaName> to role <roleName>;
To allow roles to delete talbes in a specific database.schema:
grant DELETE TABLE on <dbName>.<schmeaName> to role <roleName>;