Grant select on all tables in a schema

From: "Bob Hockney" <zeus(at)ix(dot)netcom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Grant select on all tables in a schema
Date: 2004-07-04 02:09:43
Message-ID: 40E70477.19775.4A12822@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

I am using Postgresql 7.3 and I want to grant select rights to a user to all tables in a
schema, even those tables that might be created in the future and whose names are
not yet known, without needing to explicitly grant select rights for each table. Is this
possible, or does a table need to exist before I can grant a user rights to it?

What I want to do is something like this:

GRANT SELECT ON <schema>.* TO user;

But SELECT isn't valid for schemas. Any thoughts on how to accomplish this
appreciated. I am not subscribed to the list so please cc me on replies.

-Bob

Browse pgsql-general by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2004-07-04 07:46:58 Re: alter table cascade does not give notice about dropped
Previous Message Dennis Gearon 2004-07-04 01:50:20 Re: username length character limits?