Re: grants

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