| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruno Wolff III <bruno(at)wolff(dot)to>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Latest requests from IRC |
| Date: | 2004-05-24 07:06:33 |
| Message-ID: | Pine.LNX.4.58.0405240858220.4098@sablons.cri.ensmp.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Just my two pence contribution:
> * Allow GRANT/REVOKE permissions to be given to all schema
> objects with one command
>
> > GRANT SELECT ON TABLE myschema.* TO foo
As for the style of the syntax, maybe one could consider to reuse
already available sql regexpr rather than import shell-like regexpr?
GRANT SELECT ON TABLE 'myschema.%' TO calvin;
Also, there is no reason why the schema themselves could not been
fixed similarly:
REVOKE ALL FROM SCHEMA 'abc%' FROM hobbes;
On the other hand, having actual sql regexpr may make a potential
implementation harder wrt just handling a 'myschema.*' special case.
Have a nice day,
--
Fabien.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2004-05-24 07:24:24 | Re: |
| Previous Message | Alvaro Herrera | 2004-05-24 04:14:40 | Buffer manager (was Re: relcache refcount) |