From: Thusitha Kodikara <kthusi@yahoo.com>
To: bryce1@obviously.com
To: pgsql-sql@postgresql.org
Subject: Re: grant select on database demo to user
Date: Tue, 2 May 2006 21:07:57 -0700 (PDT)
Message-ID: <20060503040757.4998.qmail@web30413.mail.mud.yahoo.com> (raw)
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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] 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
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kthusi@yahoo.com, bryce1@obviously.com
Subject: Re: grant select on database demo to user
In-Reply-To: <20060503040757.4998.qmail@web30413.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox