How to create a user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to create a user

Hybrid View

  1. #1
    Join Date
    May 2001
    Posts
    31
    Hello Everybody,

    Iam new to Oracle database administration Can anybody over here tell me how to create an Oracle User in 8i

    Thank you
    sanga

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi sanga,

    Login in as sys or system the default password when you install oracle are as follows

    sys -> change_on_install

    system -> manager

    Once you connect as the above user just type the following statements

    create user username identified by password default tablespace user temporary tablespace temp;

    grant connect,resource to username;


    The second statement is used to give the user privilege to create objects in the tablespace user

    Hope this helped

    Regards
    Santosh

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    Hi sanga,

    1) Log into sqlplus using system/manager(default password) to the database.

    2) CREATE USER USR1 IDENTIFIED BY PASSWD
    DEFAULT TABLESPACE TS_USERS
    TEMPORARY TABLESPACE TS_TEMP;

    3) GRANT CONNECT, RESOURCE TO USR1


    If you want the user to create objects on the other tablespaces , then give him his quota on the other ts as

    alter user usr1
    quota 50M on ts_users2
    ;


    If you want the user to change his password on his first login then

    alter user usr1
    password expire;

    If you want to drop the user, along with the objects created by him

    drop user usr1 cascade;

    Hope this helps
    Badrinath


  4. #4
    Join Date
    Apr 2001
    Posts
    14
    Hi,

    In Oracel 7.3 & 8 you can also create user and grant privi. to user in one statement :

    sqlplus > grant connect, dba, resource to user identified by password;

    This will create the user as well as grant privi. I have not tried this on oracle 8i. but it
    should work.

    Deval

    [Edited by Deval on 05-31-2001 at 04:36 PM]

  5. #5
    Join Date
    Apr 2001
    Posts
    2
    Hi Sanga,

    1) Log into the database (using sqlplus) as a DBA user (you can use system/manager).

    2) issue the statement:
    CREATE USER name IDENTIFIED BY password
    DEFAULT TABLESPACE tools
    TEMPORARY TABLESPACE temp
    quota 10m on tools;

    3) Then grant whatever prviliges need to that user:
    GRANT CONNECT TO name;
    GRANT RESOURCE TO name;

    hth,
    Helmut


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