Hi guys,
The latest thing we've noticed in the IRC channel and the phpPgAdmin
lists is that people want to be able to grant on all objects in a
database, etc:
grant select on all tables to blah;
or even:
grant rule on all views in schema myschema to blah;
This seriously is asked every other day
On Sun, May 23, 2004 at 12:00:29 +0800,
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> The latest thing we've noticed in the IRC channel and the phpPgAdmin
> lists is that people want to be able to grant on all objects in a
> database, etc:
The right way to do this is to ma
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
>> ... people want to be able to grant on all objects in a
>> database, etc:
> The right way to do this is to make sure there is a group that has access
> to "everything" and just add people to the
Added to TODO:
* Allow GRANT/REVOKE permissions to be given to all schema
objects with one command
---
Tom Lane wrote:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > Christopher Kings-Lynne <[EMAIL P
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 impo