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.

Report message to a moderator

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 ';

Report message to a moderator

Previous Topic: Reg-Parameters.
Next Topic: Error:table is mutating!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 15:24:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.