Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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 11.2.0.2.0 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 11.2.0.2.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    SQL> CONNECT / as sysdba
    Connected.
    SQL> CREATE USER <new_user_name> IDENTIFIED BY "<password>" 
    DEFAULT TABLESPACE "<desired_tablespace>" 
    TEMPORARY TABLESPACE temp;
    
    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

 
discard

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.