github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/007_cloudsqliamuser_access.sql (about)

     1  -- +goose Up
     2  -- +goose StatementBegin
     3  DO
     4  $$
     5      BEGIN
     6          IF EXISTS(SELECT * FROM pg_roles WHERE rolname = 'cloudsqliamuser') THEN
     7              alter default privileges in schema public grant all on tables to cloudsqliamuser;
     8              grant all on all tables in schema public to cloudsqliamuser;
     9          END IF;
    10      END
    11  $$ LANGUAGE 'plpgsql';
    12  -- +goose StatementEnd
    13  
    14  -- +goose Down
    15  -- +goose StatementBegin
    16  DO
    17  $$
    18      BEGIN
    19          IF EXISTS(SELECT * FROM pg_roles WHERE rolname = 'cloudsqliamuser') THEN
    20              alter default privileges in schema public revoke all on tables from cloudsqliamuser;
    21              revoke all on all tables in schema public from cloudsqliamuser;
    22          END IF;
    23      END
    24  $$ LANGUAGE 'plpgsql';
    25  -- +goose StatementEnd