Re: trigger from signing on?

You might want to look at Schema-Level Triggers (in 8i+). These can fire during logon/logoff.
However, unless I misunderstand your requirements, you will not be able to do what you want. How are the connections to be made? SQL*Plus? A management console? A web application? A custom server application? They will all fire the trigger and run it OK on the database but how on earth is the server going to handle all these different types of client application?

You could consider a custom application which checks for certain events, or possibly even a wrapper for SQL*Plus.

Good luck!

ETA "SPIDERMAN" <consultant2b_at_hotmail.com> wrote in message news:<uvbIa.293465$3n5.22571_at_news2.central.cox.net>...
> I don't know much about Oracle (except for the PL?SQL), so please bear with
> me. I was just wondering if there was a way to create an alert triggered by
> user signing on? I want to create an alert as a pop up dialog box (java
> function call?) that list the names of the people having birthdays (names
> and DOB's stored in a table) the following day. Can I make this as a trigger
> based on the fact that some table is automatically modified when user sign
> on? If so, what is the name of this table? What are the steps I need to
> accomplish this? Any inputs are greatly appreciated.
Received on Thu Jun 19 2003 - 07:23:58 CDT