select 'GRANT ALL PRIVILEGES ON '||relname||' TO XYZ' from pg_class
  where relkind = 'r'
  order by 1