On Wed, 10 Mar 2004, Andreas Pflug wrote:
> Edgar Mares wrote:
>
> > hi there i'm having troubles to find how to
> > GRANT SELECT ON all-tables-onmydb TO specificuser
> >
> > this is just to give the access to "specificuser" to query the
> > database and find troubles on it
>
> pgAdmin II has a tool for that (Security wizard; pgAdmin III has it on
> the todo-list)
>
The problem that cannot be solved with either this or a function that
loops and grants on each table is that it is not a permanent grant of what
the admin had in mind. If a new table is added or an existing table is
dropped and recreated, the grants must be done again. The real use of a
SELECT ANY TABLE permission is ignorance of schema updates.
Kris Jurka