Oracle 11g Related Isssues

Problem 1

I had created a new user in Oracle however when I tried logging in to Oracle Enetrprise management console using the same user I could not do so. I was getting the error "The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information."

Solution

Once a new user has been created we need to GRANT the "SELECT ANY DICTIONARY" privleges in order to log on to Oracle Enterprise Manager Console

1. create user test_user identified by test123;
2. Grant create session to test_user;
3. Grant Select Any Dictionary to test_user;

User Creation

Login to Enterprise Console : https://localhost:1158/em/console/logon/logon

Note: your port may differ based on the installation. I used the default port.