Re: create user in PL/SQL package e.t.c.

Hi!

> 1. How I can create user inside PL/SQL package?
> If it is not possible, give tips.
>
> 2. How I can get roles and system privileges granted to user?

SQL> exec execute immediate 'create user y identified by y';

PL/SQL procedure successfully completed.

SQL> exec execute immediate 'grant create session to y';

PL/SQL procedure successfully completed.

SQL> connect y/y
Connected.
SQL> Tanel. Received on Tue Sep 16 2003 - 07:42:01 CDT