Skip to content
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.

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

SIRE schema is not initialized #3

Open
ponceta opened this issue Sep 13, 2021 · 0 comments
Open

SIRE schema is not initialized #3

ponceta opened this issue Sep 13, 2021 · 0 comments
Labels
bug Something isn't working

Comments

@ponceta
Copy link
Member

ponceta commented Sep 13, 2021

Extension initialization will fail since SIRE export SCHEMA is not initialized

qwat_ch_vd_sire

CREATE SCHEMA qwat_ch_vd_sire
    AUTHORIZATION postgres;

GRANT ALL ON SCHEMA qwat_ch_vd_sire TO postgres;

GRANT ALL ON SCHEMA qwat_ch_vd_sire TO qwat_user;

GRANT USAGE ON SCHEMA qwat_ch_vd_sire TO qwat_viewer;

ALTER DEFAULT PRIVILEGES IN SCHEMA qwat_ch_vd_sire
GRANT ALL ON TABLES TO qwat_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA qwat_ch_vd_sire
GRANT SELECT, REFERENCES, TRIGGER ON TABLES TO qwat_viewer;

ALTER DEFAULT PRIVILEGES IN SCHEMA qwat_ch_vd_sire
GRANT ALL ON SEQUENCES TO qwat_user;
@ponceta ponceta added the bug Something isn't working label Sep 13, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant