Re: [SQL] grant select on database demo to user

[Thusitha Kodikara]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bryce Nesbitt
Sent: Wednesday, May 03, 2006 9:03 AM
To: pgsql-sql@postgresql.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

 

 

--