Setting up a database user in Oracle using SQL Worksheet

  1. Start the Oracle SQLPlus Worksheet and sign in as a system administrator.
  2. Specify these lines. You can specify this information for each user and then run the script collectively. 
    create user <user_name identified by <password>
default tablespace <name>
temporary tablespace <temp>;
grant connect to <user_name>;
grant create table to <user name>;

    Where:

    • <user_name> is the name of the user you are creating.
    • <password> is the password for the user.
    • <name>is the name of the tablespace you created in Create database users in Oracle.
    • <temp>is the name of the temporary tablespace.

    For example, to create a user Scott with a password of password, with access to the default tablespace Budget and default tablespace temp, you must specify: 

    create user Scott identified by password
default tablespace Budget
temporary tablespace temp;
grant connect to Scott;
grant create table to Scott;
  3. Run the commands.
  4. Verify that the commands were run successfully.

    For more information and options regarding security and interfaces, see your Oracle documentation.