grant to all tables

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: grant to all tables
Date: 2003-01-21 07:17:54
Message-ID: 20030121071754.57684.qmail@web40606.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to grant to all tables in a database
with a single sql statement - such as:

grant all on db.* to user;

If not, how's it done?

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Charpentier 2003-01-21 07:35:38 Problem with alter table (creating a foreing key post facto)
Previous Message Peter Gibbs 2003-01-21 07:04:35 Re: repost of how to do select in a constraint