grant select on database demo to user

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: grant select on database demo to user
Date: 2006-05-03 03:32:54
Message-ID: 44582466.7010303@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I find myself with long lists of tables

grant select on xx_tax to user;
grant select on xx_trip to user;
grant select on xx_foo to user;

Is there a way to grant to all tables, with a single grant? I know how
to do it in mysql, but not postgres. As close as I get it:

#grant select on database demo to user
ERROR: invalid privilege type SELECT for database

--
----
Visit http://www.obviously.com/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thusitha Kodikara 2006-05-03 04:07:57 Re: grant select on database demo to user
Previous Message Tom Lane 2006-05-03 01:28:11 Re: ERROR: plan should not reference subplan's variable