how to send a broadcast message to oracle logons?

[raygg]

I am an oracle dba and would like to know how to set up a broadcast message to all active users and anyone logging on - I never have run across this in the oracle doc manuals so there must be a way to do this with triggers and a system authority to change a users prompt or something like that.
I really would appreciate it if anyone has a solution to this.

Ray

 

[Dagon]

It depends what sort of front-end they are using. You could probably do something with login triggers and dbms_output (if they are using sqlplus or some other utility which can display the messages). Also, I think sql*plus has login.sql and glogin.sql files which can executed automatically for each user.

 

[raygg]

I forgor about the glogin and login files - that might be used to reference a literal value where a broadcast msg can be placed.

For those already logged on - they come in via sqlplus, odbc, whatever - could be anything as we have mostly if not all 3rd party vendor apps. How do you break into sessions and advise them the db has to be taken down?

raygg

 

[sem]

I used a script that notified all Windows clients by calling "net send" for all machines listed in v$session. I can not find it, but the idea is quite simple. Unfortunately it's not possible for 3-tier clients.


Regards, Dima

http://seminihin.narod.ru