New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

What are the minimum SQL priviledges required from sql_pump and sql_pump_aggregate? #723

Open

jakub-bochenski opened this issue Sep 8, 2023 · 1 comment

Labels

needs documenting

jakub-bochenski commented Sep 8, 2023

I'm guessing create table, create index and select/insert/update should be enough

This should be documented to avoid unexpected failures during runtime.

Author

jakub-bochenski commented Sep 11, 2023

This seems to be working for me

CREATE USER tyk WITH PASSWORD '12345678';
CREATE DATABASE tyk_analytics;
\connect tyk_analytics
CREATE SCHEMA tyk_schema;
GRANT CONNECT ON DATABASE tyk_analytics  TO tyk;
GRANT USAGE, CREATE ON SCHEMA tyk_schema  TO tyk;
ALTER USER tyk SET search_path TO tyk_schema;

caroltyk added the needs documenting label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment