GRANT on all tables?

From: dudsen <dudsen(at)koen(dot)dk>
To: pgsql-admin(at)postgresql(dot)org
Subject: GRANT on all tables?
Date: 2003-04-16 13:17:04
Message-ID: 1050499026.680723@kalvebod.groenjord.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

How do I GRANT an user privileges for all tables in an database with one
command, as it is now i need to specify the name of each table.
I want to write something like
GRANT SELECT,INSERT ON mydatabase TO user; this doesn't work but are there a
way of getting someting similar to work?

--
Daniel Udsen

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Liz Scates 2003-04-16 13:40:52 new user
Previous Message Greg Kelley 2003-04-16 11:24:21 Clarification on RH Upgrade, pgsql not working - erroneous pg_hba.conf