Re: Create user via stored proc/package ?

From: Steve B <steve.bright_at_capgemini.co.uk>
Date: Wed, 30 Jun 1999 12:58:23 +0100
Message-ID: <7ld0pe$jv5$1@taliesin.netcom.net.uk>

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
Received on Wed Jun 30 1999 - 06:58:23 CDT