5 PERMISSION
="${3:-SELECT}"
7 if [ "$USER" = "" ] ; then
8 echo "Usage: $0 <database> <username> [permissions]"
12 TABLES
="`psql \"$DATABASE\" -qt -c \"select relname from pg_class where relowner > 50 AND relkind in( 'r', 'S');\"`"
14 for T
in ${TABLES} ; do
15 psql
"$DATABASE" -c "grant ${PERMISSION} on ${T} to ${USER};"