Re: Insufficient Privileges in Procedure

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 25 May 2004 22:41:17 +0200
Message-ID: <bnb7b0tugbofilb4s9q5fsn236mj4coi4g@4ax.com>

On Tue, 25 May 2004 15:27:27 -0400, Rocco <poxono76521_at_att.net> wrote:

>Does anyone have any suggestion? Thanks.
>

Sure, you need to post the line no in error, because it is unclear whether the create user fails or the grant. Likely the grant, because you don't have with admin on that role.

Other than that, if you want to give away all control over your database by allowing a procedure to create account, without intervention of the DBA (and annoy the DBA), this is of course the way to go.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue May 25 2004 - 15:41:17 CDT