db='tracker' # GRANT ALL TO PUBLIC ON ALL TABLES echo " " > grant.sql for table in \ invoicelineitem expense work cashwithdrawals cashdeposits \ persbudgproj budgetproject accountsrecv project budget companyperson \ company userauth person users domain { echo "grant all on $table to public;" >> grant.sql } psql -e -f grant.sql tracker