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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])