Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create user via stored proc/package ?
Does issuing a DDL statement force a commit ? Or is it only the FORMS_DDL that
does this ?
Marc
Jens Loebling wrote:
> 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:48:00 CDT