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 Eisentraut | Date: 2005-02-01 16:30:53 |
| Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema |
| Previous: | From: Josh Berkus | Date: 2005-02-01 16:19:02 |
| Subject: Re: Allow GRANT/REVOKE permissions to be applied to all schema |