Skip site navigation (1) Skip section navigation (2)

Re: Allow GRANT/REVOKE permissions to be applied to all

From: Richard Huxton <dev(at)archonet(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all
Date: 2005-02-01 16:27:22
Message-ID: 41FFADEA.1000900@archonet.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2005-02-01 16:30:53
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema
Previous:From: Josh BerkusDate: 2005-02-01 16:19:02
Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group