When a user connects to an Oracle database, is there any way to force him to execute a script/stored procedure/function/statement/thing?
asked Nov 30 '09 at 03:50 PM in Default
There is a system level AFTER LOGON ON DATABASE trigger that can be incorporated into your database code. The trigger is executed after the user logon is processed. A trigger body can contain PL/SQL code.
Inside the trigger you have access to the username via sys_context so you can conditionally execute code if you desire.
Oracle 10g Documentation here
Here is a basic example:
answered Nov 30 '09 at 04:48 PM