Re: How to issue CREATE USER command from a stored proc?

Craig Harper wrote:
>
> I am trying to figure out how to execute a CREATE USER and
> GRANT commands from a stored proceedure. I would like to
> create the username (user_id) from a sequence generator, then
> GRANT create session to the new user. Does anyone know if this
> is possible? If so how I keep getting errors when I try.
>
> Thanks

<snip>

You can't do DDL commands (like CREATE USER) from a PL/SQL procedure. Oracle doesn't support it.

-- 
==============================================================================
Jason Wells                 Tapestry Computing, Inc.       Voice: 314.344.0066
Senior Software Developer   Email:jason.wells_at_tapestry.com   Fax: 314.344.0990
==============================================================================