Re: grant select on database demo to user

Hi,

You could easily generate a script with the list of tables and the required grant information and then run it to give the necessary grants. (The list of tables may be obtained by querying tables in 'information_schema')

Regards,
-Thusitha

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Bryce Nesbitt
Sent: Wednesday, May 03, 2006 9:03 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] grant select on database demo to user

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/



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match


--