Re: Generating GRANT/REVOKE on functions from catalog - Mailing list pgsql-general

From Tom Lane
Subject Re: Generating GRANT/REVOKE on functions from catalog
Date
Msg-id 22991.1249424643@sss.pgh.pa.us
Whole thread Raw
In response to Generating GRANT/REVOKE on functions from catalog  (Doug Gorley <doug.gorley@gmail.com>)
Responses Re: Generating GRANT/REVOKE on functions from catalog  (Doug Gorley <doug.gorley@gmail.com>)
List pgsql-general
Doug Gorley <doug.gorley@gmail.com> writes:
> The statement I need to generate is:

> revoke all on function public.add(integer, integer) from someuser;

> I'm attempting to use the pg_proc table in the system catalogs, and I'm
> good up to the point where I need the parameter types.  Can anyone give
> me a hand with this?

Personally, I'd cast the function OID to regprocedure, instead of
doing it the hard way ...

            regards, tom lane

pgsql-general by date:

Previous
From: Gert
Date:
Subject: Re: Error when assigning default value for function parameter
Next
From: Doug Gorley
Date:
Subject: Re: Generating GRANT/REVOKE on functions from catalog