On Fri, Apr 02, 2004 at 11:58:42 -0500,
John DeSoi <jd@icx.net> wrote:
> Is there a mechanism to execute a function after the user connects to
> the database? I would like to set the schema path based on the user's
> group membership. It would also be nice to log to a table on
> connect/disconnect.
You can set the schema path based on the user or the database (but not
both at once), using ALTER USER or ALTER DATABASE.