Grant select access to a user for all tables in a postgres database

readonly_db_access.sh

#!/bin/sh

tables=$(psql database_name -A -t -c "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';")

for table in $tables
do
echo "Granting select to username on $table"
psql database_name -c "GRANT SELECT ON $table to username;"
done

GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO role; is needed aswel. Will look at how to drop this down to SELECT only

Check this out: http://wiki.postgresql.org/images/d/d1/Managing_rights_in_postgresql.pdf as an alternative approach.