Hi all,
Thanks a lot for your Help.....
And Wish you a very happy & a Prosperous New Year
Regards
Almyeed
Regis Biassala <Regis.[Email Address Removed] wrote:The best way to accomplish this is by the use of e-mail.
Design a small application like this:
Suppose you have 5 databases running with multiple users...

1. Create a small DBA ControlCenter database.
2. Create DB links to connect to DBA ControlCenter from all those 5
databases.
3. Create a table(Name, Username, e-mail, database,logon_time, logoff_time,
IsUserLogged) that will hold infos on all the users connecting to your
databases.
4. Write a AFTER LOGON trigger and a AFTER LOGGOFF trigger to always update
the last 3 columns on point 3.
5. Write a store procedure in DBA ControlCenter database which will send
mail to those users whenever you want to do something.
Note: your procedure will always check the data of the table created on
point 3. before sending any mail...

Note: Asktom.oracle.com has an example which you could modify which sends an
e-mail to a group of people.

HTH,
Regis




-----Original Message-----
From: almyeed shaikh [mailto:[Email Address Removed] Monday, December 30, 2002 9:27 AM
To: LazyDBA.com Discussion
Subject: Sending Messages thru Oracle


Hi All,
I have multiple versions of Oracle running on my server. I would like to
know whether there is any way by which i can send messages to all the
connected users from my server?
please help me out in this
waiting for ur reply
regards
Almyeed







Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************



---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Oracle LazyDBA home page