Allow GRANT/REVOKE permissions to be applied to all schema objects with one command

From: Matthias Schmidt <schmidtm(at)mock-software(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
Date: 2005-01-27 07:05:45
Message-ID: DD7D9C7C-7031-11D9-A31A-000393AA75A0@mock-software.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tom + *,

as I learned from severall posts this TODO splits into two distinct
TODO's

TODO1: Allow GRANT/REVOKE permissions to be applied to all schema
objects with one command.
TODO2: Assign Permissions to schemas wich get automatically inherited
by objects created in the schema.

my questions are:

a) should we pursue both of them?
b) how can a syntax for TODO1 look like? Anchored at 'GRANT ... ON
SCHEMA' or 'GRANT ... ON <objecttype>' ?

greetings,

Matthias

----------------------------------------------------------------------
Matthias Schmidt
Viehtriftstr. 49

67346 Speyer
GERMANY

Tel.: +49 6232 4867
Fax.: +49 6232 640089

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2005-01-27 13:39:31 Re: Patent issues and 8.1
Previous Message Greg Stark 2005-01-27 05:48:53 Re: Deferrable Unique Constraints