Re: Create oracle users PL/SQL procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Apr 2002 23:59:07 +0200
Message-ID: <uc92aa248ovs07@corp.supernews.com>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3cc43bc2$0$233$ed9e5944_at_reading.news.pipex.net...
> 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
>

You are correct, but if you have to administer this db, don't you think you are loosing ALL control if you are allowing end-users to do this?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Apr 22 2002 - 16:59:07 CDT