Allow GRANT/REVOKE permissions to be applied to all schema objects with one command - Mailing list pgsql-hackers

From Matthias Schmidt
Subject Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
Date
Msg-id DD7D9C7C-7031-11D9-A31A-000393AA75A0@mock-software.de
Whole thread Raw
Responses Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command  (Matthias Schmidt <schmidtm@mock-software.de>)
List 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



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Deferrable Unique Constraints
Next
From: Hannu Krosing
Date:
Subject: Re: Concurrent free-lock