Re: Change password of a user from stored procedure

From: Venkat <vreddy_at_ix.netcom.com>
Date: Fri, 17 Apr 1998 18:01:48 -0400
Message-ID: <6h8jkc$1rs@sjx-ixn5.ix.netcom.com>

Maike ,
You have to use the DBMS_SQL package to run DDL commands from stored programs

Venkat

>I want to change the password of a db-user (Workgroup Server 7.3) from a
>stored procedure. The stored procedure will be invoked by the
>PL/SQL-Cartridge of the Web Application Server 3.0.
>
>Besides I want to create new databases users from a stored procedure
>
>Is it possible to execute sql-commands like that directly from a stored
>procedure or are there any other possibilities?
>
>Thanks in advance,
>Maike
>
>
>
Received on Fri Apr 17 1998 - 17:01:48 CDT