This is related to my question about how to set a GUC variable in general. Specifically, what I am looking for is a way to allow a non-superuser to be able to set a GUC variable using ALTER DATABASE.
I tried to issue the follow command
ALTER DATABASE my_db SET postgis.isal_enabled_drivers TO 'ENABLE_ALL';
and got:
ERROR: permission denied to set parameter "postgis.isal_enabled_drivers"
I was wondering if it is possible for the superuser to GRANT me some privileges (PostgreSQL 9.5.1) so that I can executed the ALTER DATABASE command above. If so, what is the minimum privilege that I need to ask for?