Skip to main content
Jeremy Cohen
Product Manager at dbt Labs
View all authors

Updating our permissioning guidelines: grants as configs in dbt Core v1.2

· 7 min read
Jeremy Cohen
Product Manager at dbt Labs
Doug Beatty
Senior Developer Experience Advocate at dbt Labs

If you’ve needed to grant access to a dbt model between 2019 and today, there’s a good chance you’ve come across the "The exact grant statements we use in a dbt project" post on Discourse. It explained options for covering two complementary abilities:

  1. querying relations via the "select" privilege
  2. using the schema those relations are within via the "usage" privilege