Re: [ADMIN] read only user

2005-11-11 Thread Tomeh, Husam
Husam   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin TaylorSent: Sunday, November 06, 2005 1:54 PMTo: pgsql-admin@postgresql.orgSubject: [ADMIN] read only user Hi there,  Ive google and searched the lists but havent found detailed instructions on how to give a user readly a

Re: [ADMIN] read only user

2005-11-09 Thread Walter Kaan
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 t

[ADMIN] read only user

2005-11-09 Thread Colin Taylor
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.