Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: creating users in oracle9i stored procedure
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