On Thu, Oct 16, 2003 at 10:15:47 -0700,
David Rickard <David.Rickard@GTScompanies.com> wrote:
> Is there any shorthand for granting access privileges (select etc) to all
> of the tables/views in a database or schema en masse? I have attempted
> "grant select on <schema>.* to <user>" and get "ERROR: Relation
> "<schema>"."*" does not exist" as a result;
No. You can write a script to get a list of tables (and whatever other
objects you want) and then issue a grant statement for each table.