deny create function to user on postgres

Question

How does one go about explicitly denying the create function ability of a non superuser in postgres? I looked into the documentation, but was unable to find anything of value.

Answer 1

You can look here for the documentation. You would use the Revoke command in place of grant and just specify Create.

REVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
TO { username | GROUP groupname | PUBLIC } [, ...]

EDIT:

Here is where you go for Revoke, which has more options.

REVOKE [ GRANT OPTION FOR ]
{ EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION funcname ( [ [ argmode ] [ argname ] argtype [, ...] ] ) [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]