Mike Gould writes:
After a user is authenticated on a connection, if this setting is set, then the database automatically triggers this procedure to be run.
Don't know about triggers, but I you can do "set" commands on a per user bases.
ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }