Re: Allow GRANT/REVOKE permissions to be applied to all - Mailing list pgsql-hackers

From Richard Huxton
Subject Re: Allow GRANT/REVOKE permissions to be applied to all
Date
Msg-id 41FFADEA.1000900@archonet.com
Whole thread Raw
In response to Re: Allow GRANT/REVOKE permissions to be applied to all schema  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus wrote:
> Richard,
> 
> 
>>pg_find --type=table --schema=foo --name='system_*' --execute='GRANT ALL
>>  ON % TO myuser'
> 
> 
> Hey, that's a way keen idea.   Regardless of what we do with GRANT/REVOKE.  
> You don't happen to, uh, have any code for that?

Well, currently, what you see posted above is the full extent of the 
idea. If there's a feeling it'd be useful I could pull my finger out and 
have a working prototype ready in Perl fairly quickly. It'd take me a 
while to get something decent in C though.

--  Richard Huxton  Archonet Ltd


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema
Next
From: Peter Eisentraut
Date:
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema