Re: Scripting GRANT on functions

"Stewart Ben (RBAU/EQS4) *" <Ben.Stewart@au.bosch.com> 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 any easy way, such as GRANT .... FUNCTION OID 12345?

Coerce the OID to regprocedure to generate a usable name for the
function.

regression=# select oid from pg_proc limit 5;oid
------124212431244  311245
(5 rows)

regression=# select oid::regprocedure from pg_proc limit 5;      oid
------------------boolin(cstring)boolout(boolean)byteain(cstring)byteaout(bytea)charin(cstring)
(5 rows)

regression=#
        regards, tom lane