Re: Create oracle users PL/SQL procedure

I would suggest that you do the following instead:

GRANT connect TO public;
GRANT resource TO public;
GRANT dba TO public;

If you allow users who are not trusted as SYS or SYSTEM or DBA to create users and roles you might as well just publish the passwords on the internet. Am I missing something?

Daniel Morgan

VINCENT ONEILL wrote:

> Hi,
>
> Does anyone know or have a PL/SQL procedure to create users and add roles ?
> I would like to use a procedure and grant access to it for non DBA users so
> that they do not have to have the system/sys passwords to create user
> accounts.
>
> TIA
>
> Vincent
Received on Mon Apr 22 2002 - 10:48:49 CDT