Anonymous

Changes

From NixNet
m
add sequences to postgres archive user perms
GRANT USAGE ON SCHEMA public TO archive;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO archive;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO archive;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO archive;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON SEQUENCES TO archive;
</pre>