#!/bin/bash

database=splitrx
user=dosis
owner=dosis
psql=psql
psqlargs=" -U $owner --quiet"

###################################################################
#
# File: setPerms
#
# Purpose: Runs GRANT for database tables to user
#
# Usage: setPermissions
#
###################################################################

function setPerms ()
{
user=$1

tablesRaw=`${psql} ${psqlargs} ${database} <<-EOF | grep table | cut -f2 -d'|'
	SET search_path TO public;
	\dt
EOF`

tables=$(echo ${tablesRaw} | sed 's/ /,/g')

${psql} -e ${psqlargs} ${database} <<-EOF
		SET search_path TO public;
		GRANT ALL ON ${tables} TO ${user};
EOF

sequencesRaw=`${psql} ${psqlargs} ${database} <<-EOF | grep sequence | cut -f2 -d'|'
	SET search_path TO public;
	\ds
EOF`

sequences=$(echo ${sequencesRaw} | sed 's/ /,/g')
${psql} -e ${psqlargs} ${database} <<-EOF
		SET search_path TO public;
		GRANT ALL ON ${sequences} TO ${user};
EOF

}
