Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic creatig a users
Dynamic creatig a users [message #158] Tue, 22 January 2002 05:35 Go to next message
Vasea
Messages: 5
Registered: January 2002
Junior Member
How i can create users automatic when insert the some dates in table.
Re: Dynamic creatig a users [message #161 is a reply to message #158] Tue, 22 January 2002 06:23 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

create a after insert trigger on the table and use execute immediate or dbms_sql to create user.

hope u got the idea.

cheers
pratap
Previous Topic: Insufficent privileges? referencing
Next Topic: V$RECOVER_FILE Problem
Goto Forum:
  


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