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

From Alvaro Herrera
Subject Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
Date
Msg-id 20050129022605.GA28498@dcc.uchile.cl
Whole thread Raw
In response to Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command  (Matthias Schmidt <schmidtm@mock-software.de>)
Responses Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command  (Kevin Brown <kevin@sysexperts.com>)
Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Jan 28, 2005 at 09:17:46PM +0100, Matthias Schmidt wrote:

> a) accept some sort of wildcard for the grant on table syntax:
>    GRANT ... ON TABLE schema.*

What about a list,

GRANT ... ON TABLE table1, table2, ... TO user1, user2, ...;

It would be good if it was a list of wildcards.  Not sure if that is
workable.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-hackers] Allow GRANT/REVOKE permissions to be applied to all schema
Next
From: Kevin Brown
Date:
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command