dbt macro to grant select usage and select for all tables of a schema

grant_select_on_schemas.sql

{% macro grant_select_on_schemas(schemas, user) %}
  {% for schema in schemas %}
    grant usage on schema {{ schema }} to "{{ user }}";
    grant select on all tables in schema {{ schema }} to "{{ user }}";
    alter default privileges in schema {{ schema }}
        grant select on tables to "{{ user }}";
  {% endfor %}
{% endmacro %}