grant select permission for given database (tables) to given database user

grant_ro_pgsql_access.sh

#!/bin/bash
#
# Grant SELECT on database to given username
#    ./grant_ro_pgsql_access.sh dbname dbuser
#

function usage {
    echo "Usage: $0 dbname dbuser"
}

DB=$1
USER=$2

if [ -z "$DB" -o -z "$USER" ]; then
    usage
    exit 0;
fi

psql -U postgres -qAt -c "select 'grant select on ' || tablename || ' to \"${USER}\";' from pg_tables where schemaname = 'public'" ${DB} | psql -U postgres ${DB}