Re: Create user via stored proc/package ?

From: Jens Loebling <jens.loebling_at_o-tel-o.com>
Date: Wed, 30 Jun 1999 20:08:44 +0200
Message-ID: <377A5D2C.DA950673@o-tel-o.com>

Steve B schrieb:
>
> You can use the DBMS_SQL package to write dynamic sql statements, including
> DDL..
>
> Note : Since you will be running these statements from within stored
> procedures then grant create / alter user etc must be expicitly granted to
> the user running the procedures, and not granted via roles..
>
> hope this helps
>
> Cheers
>
> Steve Bright
>
> steve.bright_at_capgemini.co.uk
>
> Adrian Harrison wrote in message <3779f20e.11439609_at_news.globalnet.co.uk>...
> >Using VB6 Enterprise & Oracle 7.34
> >
> >Is it possible to use "CREATE USER", "ALTER USER" etc.. statements in a
> stored procedure or package
> >so that I can call them from my program thereby providing full user
> maintainence ?
> >
> >If not what's the best I can achieve?
> >
> >Thanks
> >
> >Adrian Harrison

Hallo Adrian

be careful with this point because DDL commands have a implicit commit

Jens Received on Wed Jun 30 1999 - 13:08:44 CDT