Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: creating users in oracle9i stored procedure

Re: creating users in oracle9i stored procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 21 Jan 2002 18:47:04 +0100
Message-ID: <7vko4ugs5sp43equig4668o0jn5rlfri6l@4ax.com>


On Mon, 21 Jan 2002 10:21:48 +0100, Marcin Buchwald <Marcin.Buchwald_at_agora.pl> wrote:

>I am sorry for posting this the second time.
>The only answer I got is that there is a kind of grant problem
>It did not give me so much
>
>*************************************************
>
>In previous to 9i releases of database
>I used stored procedures to register user accounts.
>It looks like
>
>create procedure (....)
>as begin
> execute immediate 'create user '||vloginname||' identified by
>'change_it' ;
>
> execute immediate 'grant connect,unlimited tablespace to
>'||vloginname;
>
> MY_APPLICATION_SPECIFIC_COMMANDS
>end;
>
>In 9i this no longer works. Oracle reports access rights error.
>
>ORA-01031: niewystarczaj?ce uprawnienia
>ORA-06512: przy "PROMO.ADD_PROMO_USER", linia 11
>
>It happens even when both the procedure owner (that has DBA granted) and
>caller are SYS.
>
>The question is: How to create user in stored procedure in Oracle9iNTEE
>?
>
>
>Regards,
>
> Marcin
>
>

Privilege through a role. The solution to this has been posted often enough now.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jan 21 2002 - 11:47:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US