RE: create user (dynamic SQL)

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 18 Oct 2004 11:44:12 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DF53@usahm018.exmi01.exch.eds.com>

Greg, here is something to look at

set echo off
--

Example plsql script to perform ddl: create user for username passed in
--
20021016 Mark D Powell Save code created as newsgroup query response
as future reference
--
set serveroutput on create or replace procedure dyn_cre_usr ( p_username in varchar2 ,p_pswd in varchar2 ) is
--
v_user varchar2(30) ; v_rest varchar2(90) ;
--
begin
--
Convert parms to uppercase (not technically necessary)
--
v_user := upper(p_username) ; v_pswd := upper(p_pswd) ;
--
Build the command
--
v_rest := ' identified by '||v_user||chr(10)|| 'default tablespace usr' ||chr(10)|| 'temporary tablespace tmp';
--
Execute the command
--
execute immediate 'create user '||v_user||v_rest;
--
end; /

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Greg Faktor Sent: Monday, October 18, 2004 11:25 AM
To: oracle-l_at_freelists.org
Subject: create user (dynamic SQL)

Hi All!

I'm looking for dynamic SQL to generate create user statement based on username.

Thanks.

Greg
--

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 18 2004 - 10:40:31 CDT