Extensions that are marked as "trusted" by a superuser can subsequently be installed via CREATE EXTENSION by unprivileged users. Some functions are marked as "trusted" by default.
For more information, please see the CREATE EXTENSION documentation.