Home » SQL & PL/SQL » SQL & PL/SQL » Using create ... in trigger
Using create ... in trigger [message #155] Mon, 21 January 2002 20:34 Go to next message
Anatol
Messages: 15
Registered: January 2002
Junior Member
I need automatic to create user but take a mistake that this command cannot be write here.
Re: Using create ... in trigger [message #156 is a reply to message #155] Mon, 21 January 2002 21:12 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Use the following statement
in your row level trigger this will create a user satish with password satish .
Only for oracle 8i , if you are working on 7.3 or 8 , use dbms_sql package

execute immediate 'create user satish identified by satish ';
Previous Topic: Reg-Parameters.
Next Topic: Error:table is mutating!
Goto Forum:
  


Current Time: Mon Aug 02 11:41:10 CDT 2021