Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
create user dbt with password '<your_password>'
nocreatedb nocreateuser syslog access restricted
connection limit 10;
create group dbt with user dbt;
-- external tables
grant usage on schema tickit_external to group dbt;
grant create on schema tickit_external to group dbt;
grant all on all tables in schema tickit_external to group dbt;
-- dbt models: tables and view
grant usage on schema tickit_dbt to group dbt;
grant create on schema tickit_dbt to group dbt;
grant all on all tables in schema tickit_dbt to group dbt;
-- reassign schema ownership to dbt
alter schema tickit_dbt owner to dbt;
alter schema tickit_external owner to dbt;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment