DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003

    Question Adding users to oracle 9i

    Dear all,
    I have installed oracle 9i on my computer whose name is SENEGALENSIS. I wish to add users to the oracle database so that they can be able to log into the database whose SID name is MWANGI.
    I have tried oracle administration for windows NT but can't get round it.
    Any help will be highly appreciated.


  2. #2
    Join Date
    Feb 2003
    Leeds, UK
    Connect to the database via SQL*Plus from command line as the SYS user. On Unix you do this with

    sqlplus " / AS SYSDBA"

    I assume this works on NT too.


    SQL> create user username identified by password
    default tablespace users
    temporary tablespace temp;

    SQL> grant create session to username;

    Where username and password are the username and password of your choice. This assumes your temporary tablespace is called temp and you have a users tablespace.

    From here you can grant additional privileges and roles as appropriate. Rember that after you've granted create table to a user you must also (again as SYS)

    SQL> alter user username quota unlimited on tablespace;

    Where tablespace is the tablespace you want the user to be able to create tables and indexes in.
    Last edited by hacketta1; 07-05-2003 at 09:01 AM.

  3. #3
    Join Date
    Sep 2002
    and the documentation IS so very very clear on this

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.