| New user not connecting thru EM [message #252145] |
Tue, 17 July 2007 23:35  |
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
|
Member |
|
|
Hi
I have created a new user ,granted connect,resource priveleges to him .I able to connect thru sql*plus tool.But using EM i am not able to connect thru EM ,getting error like below
Error Message :
---------------
The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information.
whether i should grant any extra privilege to user to connect thru EM
by
sbmk_design
|
|
|
|
| Re: New user not connecting thru EM [message #252178 is a reply to message #252145] |
Wed, 18 July 2007 01:31  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You must have at SELECT_CATALOG_ROLE role or SELECT ANY DICTIONARY privilege to connect through EM.
These one are not included in CONNECT and RESOURCE roles.
By the way, don't use these roles. Define yours with the appropriate privileges you need.
These roles are Oracle proprietary, they do what they want with them. You will be surprised to see your applications failed after an upgrade just because Oracle decides to change (or even drop) these roles.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
