Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group