Re: creating users in stored procedures

From: Mark & Kristi Wagoner <mwagoner_at_iac.net>
Date: Fri, 18 Jan 2002 20:20:25 -0500
Message-ID: <a2ahko$16m7$1@genma.iac.net>

I have a stored procedure under 9i that creates users and alters them so they can connect through a proxy account. And the procedure is owned by a non-sys account.

You must have some sort of grant problem.

"Marcin Buchwald" <Marcin.Buchwald_at_agora.pl> wrote in message news:3C47FFA6.3C068BB4_at_agora.pl...
>
> In previous to 9i releases of database I used stored procedures to
> register user accounts.
> It look like
>
> create procedure (....)
> as begin
> execute immediate 'create user '||vloginname||' identified by
> 'change_it' ;
> -- uprawnienia w bazie
> execute immediate 'grant connect,unlimited tablespace to
> '||vloginname;
> -- rejestracja w spacer_users
> MY_APPLICATION_SPECIFIC_COMMANDS
> end;
>
> In 9i this no longer works. Oracle reports access rights error.
> It happens even when both the procedure owner and caller are SYS.
>
> The question is: How to create user in stored procedure in Oracle9iNTEE
> ?
>
> Regards,
>
> Marcin
>
Received on Fri Jan 18 2002 - 19:20:25 CST