Home » RDBMS Server » Server Administration » Create User Email (9i Linux)
Create User Email [message #500660] Tue, 22 March 2011 12:27 Go to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Hi
I want whenever a user is created in database the server send me a mail about this.....
How can I do that.

Report message to a moderator

Re: Create User Email [message #500661 is a reply to message #500660] Tue, 22 March 2011 12:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How can I do that.
write a trigger

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Create User Email [message #500663 is a reply to message #500661] Tue, 22 March 2011 12:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
write a trigger

... after DDL and use UTL_MAIL to send you a mail.

Regards
Michel

Report message to a moderator

Re: Create User Email [message #500668 is a reply to message #500663] Tue, 22 March 2011 12:59 Go to previous message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
...or rather UTL_SMTP as UTL_MAIL does not exist in 9i as BlackSwan pointed me out (you will find a mail package from this package on AskTom site).

Regards
Michel

[Updated on: Tue, 22 March 2011 13:00]

Report message to a moderator

Previous Topic: Upgrade 9i to 10g using RMAN backup. Is it failed?
Next Topic: Unable to start second node in RAC
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 08 02:34:30 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.