> I believe the spec just demands USAGE on the underlying function for
> the TRANSLATE case, and I don't see why it should be different for
> CONVERT. (In principle, if we didn't use a C-only API, you could
> just call the underlying function directly; so there's little point
> in having protection restrictions different from that case.)
Ok, so:
(1) a CONVERSION can only be dropped by the superuser or its owner.
(2) a grant syntax for CONVERSION is:
GRANT USAGE ON CONVERSION <conversion_name> to {<user_name> | GROUP <group_name> | PUBLIC} [, ...]
--
Tatsuo Ishii