First, you must have access to the database as a superuser in order to delegate powers. Here, we assume the use of the default superuser named postgres.
We will demonstrate two ways to make some superuser-only functionality available to a selected ordinary user.