Re: The application requires more database privileges than you have currently been granted.
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Mar 2008 09:44:10 -0800
Message-ID: <1204911848.603827@bubbleator.drizzle.com>
>
> The Oracle version is 10.2.0.1. 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.
>
>
> 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
Date: Fri, 07 Mar 2008 09:44:10 -0800
Message-ID: <1204911848.603827@bubbleator.drizzle.com>
Gustaf wrote:
> fitzjarrell_at_cox.net 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 10.2.0.1. 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Mar 07 2008 - 11:44:10 CST