While writing about the database and user-specific session defaults, it
occurred to me, there's a more general feature lurking. Users or admins
could register an SQL-realm function that is executed before the session
starts. That way you could, say, implement a connection audit with
arbitrary alert actions.
I don't mean this to replace the proposed system of session defaults,
since this new idea would probably be a lot more complex and slow, but
it's something to think about.
--
Peter Eisentraut peter_e(at)gmx(dot)net