Re: grant select on all tables of schema or database

That would indeed be a handy feature... I was surprised when I discovered
this was not available like in mysql, it's a real pain to grant permissions
to a bunch of tables without querying table metadata.

GRANT ALL ON TABLE *.* TO joeblow

>
> which would indeed be a useful thing to have, but it's *not* GRANT ON
> DATABASE.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--
Gene Hart
cell: 443-604-2679