[CT-718] Add Grants to Materializations

[nathaniel-may]

blocked by: dbt-labs/dbt-core#5263

Once the above work is merged into core, there are some tweaks that need to be made in the spark adapter to fully expose the feature:

• add a call to apply_grants(..., revoke=True) to all custom materializations

[jtcohen6]

Important clarification that this functionality may only be available on the Databricks Runtime today, since I can't find OSS Apache Spark docs about it. I imagine (hope) it would become available in a future version, though, so I think dbt-spark is still probably the right place to put it. Open to feedback from Databricks folks if that's not the case.

• get_grant_sql: https://docs.databricks.com/spark/latest/spark-sql/language-manual/security-grant.html (default should work)
• get_revoke_sql: https://docs.databricks.com/spark/latest/spark-sql/language-manual/security-revoke.html (default should work)
• get_show_grants_sql: https://docs.databricks.com/spark/latest/spark-sql/language-manual/security-show-grant.html (default should work — even though the docs only include show grant (singular), I've tested show grants (plural) and it works equivalently)