Re: Generating GRANT/REVOKE on functions from catalog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Gorley <doug(dot)gorley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Generating GRANT/REVOKE on functions from catalog
Date: 2009-08-04 22:24:03
Message-ID: 22991.1249424643@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug Gorley <doug(dot)gorley(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug Gorley 2009-08-04 22:45:02 Re: Generating GRANT/REVOKE on functions from catalog
Previous Message Paul Taylor 2009-08-04 22:08:15 Re: Does derby have an embedded Mode like Derby ?