 | |
The application requires more database privileges than you have currentlybeen granted.
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: The application requires more database privileges than you havecurrently been granted. -
03-07-2008
, 11:44 AM
|
fitzjarrell (AT) cox (DOT) 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 |
and due to Oracle improving security now only contains CREATE SESSION.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#32
| |||
| |||
|
|
fitzjarrell (AT) cox (DOT) 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 |
and due to Oracle improving security now only contains CREATE SESSION.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#33
| |||
| |||
|
|
fitzjarrell (AT) cox (DOT) 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 |
and due to Oracle improving security now only contains CREATE SESSION.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.