Home » RDBMS Server » Enterprise Manager » New user not connecting thru EM
New user not connecting thru EM [message #252145] Tue, 17 July 2007 23:35 Go to next message
Messages: 88
Registered: April 2007
Location: CHENNAI
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

Re: New user not connecting thru EM [message #252178 is a reply to message #252145] Wed, 18 July 2007 01:31 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: OEM database control
Goto Forum:

Current Time: Mon Jul 24 21:54:32 CDT 2017

Total time taken to generate the page: 0.10717 seconds