Re: The application requires more database privileges than you have currently been granted.

From: DA Morgan <>
Date: Fri, 07 Mar 2008 09:44:10 -0800
Message-ID: <>

Gustaf wrote:
> wrote:

>> * For which release of Oracle was this application originally written?
>> * Which release of Oracle (all four or five numbers) are you using
>> which generates these errors?

> The Oracle version is I don't know what 'application' means
> here. Is it yet another name for 'user', 'account' and 'schema'? So far,
> I'm doing everything in Enterprise Manager.
>> CONNECT has been dramatically altered in 10.1.0.x and later releases
>> of Oracle.  The granted privileges have been seriously reduced to
>> nothing more than CREATE SESSION.

> That's what I see too. A new user only has the CONNECT rule by default,
> and the CONNECT role only has the CREATE SESSION privilege. But that's
> obviously not enough to use the account.
> Gustaf

You should never grant the CONNECT role to anyone. It is deprecated and due to Oracle improving security now only contains CREATE SESSION.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Mar 07 2008 - 11:44:10 CST

Original text of this message