In case we ignore the custom schema recommendation by dbt for Dev and QA environment, and have them in same schema as Prod. What are the disadvantage or possible issues with this approach in a multi-user environment?

Currently we are using the following macro (not recommended by dbt):