| 36. 1. 1. Creating a User |
|
|
To create a user in the database, you use the CREATE USER statement. |
The simplified syntax for the CREATE USER statement is as follows: |
|
CREATE USER user_name IDENTIFIED BY password
[DEFAULT TABLESPACE default_tablespace]
[TEMPORARY TABLESPACE temp_tablespace];
|
|
where |
- If you omit a default tablespace, the default SYSTEM tablespace is used.
- Tablespaces are used by the database to separate objects.
- temp_tablespace specifies the default tablespace where temporary objects are stored.
- If you omit a temporary tablespace, the default SYSTEM tablespace is used.
|