Skip site navigation (1) Skip section navigation (2)

Re: grant select on database demo to user

From: Thusitha Kodikara <kthusi(at)yahoo(dot)com>
To: bryce1(at)obviously(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: grant select on database demo to user
Date: 2006-05-03 04:07:57
Message-ID: 20060503040757.4998.qmail@web30413.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-sql
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
   
   
  -- 
  

pgsql-sql by date

Next:From: Ben K.Date: 2006-05-03 04:17:47
Subject: Re: Sorting aggregate column contents
Previous:From: Bryce NesbittDate: 2006-05-03 03:32:54
Subject: grant select on database demo to user

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group