Hi Colin, If its a one-off I usually do this in pgadmin3 by right clicking on the schema and doing the grant wizard from there. Regards Walter On Mon, 2005-11-07 at 10:54 +1300, Colin Taylor wrote: > Hi there, Ive google and searched the lists but havent found detailed > instructions on how to give a user readly access to a schema. Is there > a way to do this with out explictly granting the SELECT privilege on > every table? > > Thanks and regards, > Colin. -- Walter Kaan IM/IT Manager NSW Rural Doctors Network www.nswrdn.com.au ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
