OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Create User Email (9i Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create User Email [message #500660]

Tue, 22 March 2011 12:27

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

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

Michel Cadot
Messages: 68718
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

Michel Cadot
Messages: 68718
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:42:07 CST 2024