Manage grants for automatically created tables
As we can now create tables automatically using the schema_apply
action in our custom extraction jobs, how should we ensure the correct grants are also applied?
Right now the mkto.*
and zendesk.*
schemas both have tables being populated but only the gitlab
user can read the data.
From analytics#43 I see that the analytics
role should have SELECT
on these tables, but right now we don't do it automatically.
I think that should be specified in the catalog
that we will create.