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
>
> --
>
> Craig Harper
> IFTN
> (v) 415.583.4528
> (f) 415.583.5536
>
> Thinking is more interesting than knowing,
> but less interesting than looking.

Hi,

Use the package DBMS_SQL. It can be used to execute any kind of SQL statement inside a string.

Look in the package specification for help on how to use it.

I hope it helps.

Yves. Received on Mon May 27 1996 - 00:00:00 CEST