Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I downloaded the Oracle VirtualBox VM containing Oracle SQL Server 11g and all their dev tools. (There's not much documentation along with it and I had to find fragments of info here and there.) Anyhow, I was reading the Oracle's documentation for creating a new user, but the documentation is for 10g. Well, I'm not sure what are the differences between 11g and 10g, but I sure don't see any "Users" page anywhere in the Enterprise Manager application.

Would someone be kind enough to point me where the Users page in Oracle Enterprise Manager 11g actually is? Thank you!

share|improve this question
up vote 2 down vote accepted

It should be available under Server -> Security

Oracle Enterprise Manager

share|improve this answer
ah! I guess I missed that one then. Thank you! – Yanick Rochon Apr 8 '11 at 4:47
You're welcome @Yanick – Sathya Apr 8 '11 at 5:44

Well, after a lack of finding useful information, here's what I did. (For posterity.)

  1. Optionally create a tablespace in Enterprise Manager 11g (under Server tab)
  2. Fire up a terminal console and type

    $ sqlplus
    SQL*Plus: Release Production on Thu Apr 7 20:22:46 2011
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    Enter user-name: <your username here>
    Enter password: <your password here>
    Connected to:
    Oracle Database 11g Enterprise Edition Release - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    SQL> CONNECT / as sysdba
    SQL> CREATE USER <new_user_name> IDENTIFIED BY "<password>" 
    DEFAULT TABLESPACE "<desired_tablespace>" 
    User created.
    SQL> GRANT CONNECT, RESOURCE TO <new_user_name>;
    Grant succeeded.
    SQL> GRANT DBA TO <new_user_name>;
    Grant succeeded.
    SQL> ALTER USER <new_user_name> QUOTA UNLIMITED ON <desired_tablespace>;
    User altered.
    SQL> exit
  3. You now have a working new user

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.