Introduction¶

DROP TABLE public."raw.vsd_securities_list" CASCADE;
ALTER TABLE raw.eod_vs OWNER TO postgres;

ALTER GROUP group_read_only DROP USER nqtrg_rw;

REASSIGN OWNED BY nqtrg_rw TO postgres;
DROP OWNED BY nqtrg_rw CASCADE;

REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA production_marts FROM nqtrg_rw CASCADE ;
REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA production_marts FROM nqtrg_rw CASCADE ;
REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA production_marts FROM nqtrg_rw CASCADE ;

ALTER DEFAULT PRIVILEGES FOR USER nqtrg_rw IN SCHEMA public
   REVOKE ALL ON TABLES FROM nqtrg_rw;

ALTER SCHEMA staging_edwh OWNER TO postgres;
ALTER SCHEMA public OWNER TO postgres;

DROP SCHEMA staging_edwh CASCADE;
postgres

GRANT USAGE ON SCHEMA production_marts TO dbt;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA production_marts TO dbt;
DROP SCHEMA nhmai_marts CASCADE;
REVOKE ALL PRIVILEGES ON DATABASE XX FROM nqtrg_rw;
DROP USER nqtrg_rw;

ALTER DEFAULT PRIVILEGES IN SCHEMA production_marts GRANT ALL PRIVILEGES ON TABLES TO postgres;
ALTER DEFAULT PRIVILEGES IN SCHEMA production_marts GRANT ALL PRIVILEGES ON TABLES TO postgres;

ALTER DEFAULT PRIVILEGES FOR nqtrg_rw REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;