Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> CREATE USER DYNAMICALLY USING PL/SQL?

CREATE USER DYNAMICALLY USING PL/SQL?

From: Ellie Fillmore <efillmore_at_earthlink.net>
Date: Tue, 2 Mar 1999 21:45:51 -0500
Message-ID: <7bi7o9$2p3$1@birch.prod.itd.earthlink.net> 





I have a need to create a new oracle user upon insertion of a row into a
table.  Right now it is a manual process and we need to automate it.  I have
tried with a stored procedure using DBMS_SQL.PARSE but I cannot get past the
create user portion of it.  Any suggestions or even code if available would
help??!!


Thanks,


Ellie




Received on Tue Mar 02 1999 - 20:45:51 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US