Create A New User

Syntax 

Create_user::=

- Create user example:

SQL> CREATE USER user1 
    IDENTIFIED BY user1password
    DEFAULT TABLESPACE data1 
    QUOTA 10M ON data1 
    TEMPORARY TABLESPACE temp
    QUOTA 5M ON system 
    PROFILE app_user 
    PASSWORD EXPIRE;

- Create External user example:

SQL> CREATE USER ops$external_user
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE example
QUOTA 5M ON example
PROFILE app_user;  

- Create Globally user example:

SQL> CREATE USER global_user
IDENTIFIED GLOBALLY AS 'CN=analyst, OU=division1, O=oracle, C=US'
DEFAULT TABLESPACE example
QUOTA 5M ON example;