Grant Select privileges for all tables in schema

From: zeus(at)ix(dot)netcom(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Grant Select privileges for all tables in schema
Date: 2004-07-06 22:44:01
Message-ID: 8717756.1089153842355.JavaMail.root@statler.psp.pas.earthlink.net
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 on all tables in a schema, including those that may be created in the future but whose names are not yet known. I want to do something like:

GRANT SELECT ON <schema>.* TO <user>;

but select isn't a valid privilege on a schema and I don't see how wildcards are supported. Is there a way to do this, or does a table need to exist before a user can be granted rights to it, and users must be explicitly granted rights to each table and not in a 'global' way. I would appreciate any thoughts on this.

-Bob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo Pinto Neto 2004-07-07 00:02:14 Re: could not access file "$libdir/plpython" when restoring
Previous Message Tony Li 2004-07-06 22:42:47 Syntax question