gistfile1.txt

create user django with password 'password';
create schema django authorization django;
create user rails with password 'password';
create schema rails authorization rails;
create extension hstore;
create extension pg_trgm schema rails;
grant USAGE on SCHEMA rails to django;
ALTER DEFAULT PRIVILEGES IN SCHEMA rails revoke all on tables from django;
ALTER DEFAULT PRIVILEGES IN SCHEMA rails grant select on tables to django;
ALTER DEFAULT PRIVILEGES IN SCHEMA rails revoke all on sequences from django;
ALTER DEFAULT PRIVILEGES IN SCHEMA rails grant select on sequences to django;

# ALTER DEFAULT PRIVILEGES IN SCHEMA django revoke all on tables from rails;
# ALTER DEFAULT PRIVILEGES IN SCHEMA django grant select on tables to rails;