access privileges: grant select on (all current and future tables)?

From: "John Smith" <jayzee(dot)smith(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: access privileges: grant select on (all current and future tables)?
Date: 2007-09-27 14:07:19
Message-ID: f029597e0709270707w1c883976of829b702b05bbd13@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

how'd i "grant select on (all current and future tables inside a
private schema) to username" without turning that user into superuser?
"grant usage on..." doesn't do it.

or do i, everytime i batch/auto create the tables, do a "grant select
on (new table) to username"?

http://www.postgresql.org/docs/8.1/static/sql-grant.html
CREATE: For schemas, allows new objects to be created within the
schema. To rename an existing object, you must own the object and have
this privilege for the containing schema.
USAGE: For schemas, allows access to objects contained in the
specified schema (assuming that the objects' own privilege
requirements are also met). Essentially this allows the grantee to
"look up" objects within the schema.

using 8.1.4
cheers, jzs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nis Jørgensen 2007-09-27 14:15:59 Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
Previous Message Christian Rengstl 2007-09-27 13:42:51 Re: TSearch - Bulgarian