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
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 Go to previous message
Michel Cadot
Messages: 64139
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.

Regards
Michel
Previous Topic: OEM database control
Next Topic: EM NOT WORKING
Goto Forum:
  


Current Time: Thu Dec 08 14:33:03 CST 2016

Total time taken to generate the page: 0.36088 seconds