dba/grant-on-all-tables.sh

   1 #!/bin/sh
   2
   3 DATABASE="$1"
   4 USER="$2"
   5 PERMISSION="${3:-SELECT}"
   6
   7 if [ "$USER" = "" ] ; then
   8   echo "Usage: $0 <database> <username> [permissions]"
   9   exit
  10 fi
  11
  12 TABLES="`psql \"$DATABASE\" -qt -c \"select relname  from pg_class where relowner > 50 AND relkind in( 'r', 'S');\"`"
  13
  14 for T in ${TABLES} ; do
  15   psql "$DATABASE" -c "grant ${PERMISSION} on ${T} to ${USER};"
  16 done