Home » RDBMS Server » Enterprise Manager » Can't connect by EM (RedHat 4 EL)
Can't connect by EM [message #354899] Tue, 21 October 2008 22:55 Go to next message
meo_beo
Messages: 12
Registered: September 2008
Junior Member
Hi guys, I'm running Oracle 10g on RedHat 4 EL. After I created a new user and assigned role "Connect" to it, I tried to log in by sqlplus and isqlplus and no problems occurred. However, when I tried to log in with Enterprise Manager in "Normal" mode, it always displayed an error message like this "The application requires more database privileges than you have currently been granted.". Actually, I'm quite confused, I don't know what privileges I have to assign to this user so that I can log in with it by EM. Anyone knows what the problem is?

[Updated on: Tue, 21 October 2008 22:56]

Report message to a moderator

Re: Can't connect by EM [message #354906 is a reply to message #354899] Tue, 21 October 2008 23:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You need to have select_catalog_role role or select any dictionary privilege in order to use EM.

Regards
Michel

[Updated on: Tue, 21 October 2008 23:28]

Report message to a moderator

Re: Can't connect by EM [message #355785 is a reply to message #354906] Mon, 27 October 2008 09:23 Go to previous messageGo to next message
meo_beo
Messages: 12
Registered: September 2008
Junior Member
Thank you, I did it.
Re: Can't connect by EM [message #359434 is a reply to message #354906] Sun, 16 November 2008 02:46 Go to previous message
meo_beo
Messages: 12
Registered: September 2008
Junior Member
Although I can now connect to EM as a normal user, a new problem arises. If I grant select any catalog role or select any dictionary privilege to that user, then that user can view any table in other schemas, whereas I only want that user to view some particular tables, not all. So how can I do that? Is there any other privilege or role that just gives a user the ability to connect to EM only, but still some data are hidden from him, or if that user is allowed to access EM, that means he/she can view any data without any restriction?
Previous Topic: Can I delete em.nohup in sysman log folder
Next Topic: problem in opening?
Goto Forum:
  


Current Time: Thu Mar 28 09:58:49 CDT 2024