I should have just given you this example in my earlier reply- this is how I quickly get a batch of grant statements- you can probably modify it for your needs:
select 'grant select on '||relname||'to "www-data";' from pg_class where relname not like 'pg%'; -Nick > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Jodi Kanter > Sent: Monday, January 07, 2002 4:02 PM > To: Postgres Admin List > Subject: [ADMIN] granting all to user > > > Can I grant a user all privileges to all the tables without > having to type a > grant command for each table individually? > > I know that I can use: > grant all on object to username > > but I would like to set this person up as a superuser for now so > that he can > assist with development. > > It appears that when I set up users the default is NOT to give them access > to any of the tables. I would like to have the default set so > that users can > read all the tables and then have the option to give this one particular > person full access. > > Any suggestions??? > thanks > Jodi > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
