Re: Autofunctions/execute at connect-time ?

A copy of this was sent to "Stein Andersen" <stein.andersen_at_c2i.net> (if that email address didn't require changing) On Fri, 14 May 1999 20:49:44 +0200, you wrote:

>Using Oracle 7.2.x, Oracle 7.3.x and Oracle 8.x
>
>Does anybody know a way to automaticly execute/trigger a procedure/function
>or a
>set of statements when connecting a specific user to the database.
>
>We are depending on specific settings of environment and init-actions that
>should be performed before any normal activity in the database. Since the
>database is accessed both from application and various report-tools the
>initsialisation has to be controlled from the server.
>
>Since it is a mixed environment the setting on the user-side may differ from
>the
>required one. The application-schema is in some cases only one of several
>in a database, the triggering must therefore be connected to the user.
>
>stein.andersen_at_c2i.net
>
>

This is available with Oracle8i, release 8.1. Prior to that -- no, you cannot do this (don't even try to create a trigger on the audit table or anything like that, it won't work)...

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri May 14 1999 - 14:54:06 CDT