"Stewart Ben (RBAU/EQS4) *" <[EMAIL PROTECTED]> writes:
> Is there any easy way to script granting privileges to a number of
> functions? I've got as far as the following code before realising that
> I'll need to pass in the arguments, and the arguments are stored as OIDs
> in pg_proc.
> Is there
You could continue with this function, with an
additional cursor to get the parameters for the function. If this is a one off
thing, that you just need to do once, you could use pg_dump to get the create
function statements and then simply alter them with an re in your favorite
editor.
Yo
