That grant execute to .. does not confer the underlying privileges. so the
user can be allowed to create users through the stored procedure without
having dba access to the system.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3CC430D2.FF6D2E54_at_exesolutions.com...
> 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 - 11:35:13 CDT
