grant select on database demo to user - Mailing list pgsql-sql

From Bryce Nesbitt
Subject grant select on database demo to user
Date
Msg-id 44582466.7010303@obviously.com
Whole thread Raw
Responses Re: grant select on database demo to user
List 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/




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: plan should not reference subplan's variable
Next
From: Thusitha Kodikara
Date:
Subject: Re: grant select on database demo to user