create function - user permissions

Hi,

one of my users wants to create functions using the C language, but pgs
says "no permission".

How can I permit the user to do this, while avoiding to give him root
access rights?

Thanks,

Markus