Andreas Pflug wrote:
> Merlin Moncure wrote:
> >>>3) Allow GRANT/REVOKE permissions to be applied to all schema
> > objects
> >>>with one
> >>Maybe this is "apply schema changes to several objects with one
> >>command". This seems reasonable.
> > Well, I don't know. IMO, what I would really like to see is for various
> > database objects to inherit permissions from the schema. The ability to
> > GRANT to all tables in a schema, etc. is almost trivial to implement in
> > plpgsql/dynamic sql currently.
> And pgAdmin3 V1.2 has the Grant Wizard, as pgAdmin2 had. Though an SQL
> command for granting on multiple objects won't hurt.
> > However the major annoyance with that
> > approach is that I have to remember to re-grant permissions to tables in
> > a schema after running that function. As worded, the TODO does not
> > solve that problem.
> > IOW, I would really like to see the TODO to be reworded 'allow schema
> > objects to inherit permissions from the schema' or something like
> > this...
> This sounds quite helpful too, but I'd call it a second TODO.
Added to TODO:
* Allow GRANT/REVOKE permissions to be inherited by objects based on
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2005-02-01 04:56:38|
|Subject: Re: Proposed TODO: fetch->INT8|
|Previous:||From: Tom Lane||Date: 2005-02-01 03:45:08|
|Subject: Re: [Feed-back] Installing PostgreSQL 8.0.0 on SPARC/Solaris. Configure and install issues. |