create user user_name identified by password
default tablespace XXXX
temporary tablespace *****
---------------------
default tablespace XXXX
temporary tablespace *****
---------------------
So when creating objects under this user , if you don't specify
the tablespace , the default tablespace will be used for that object (table , index)
default tablespace USERS
temporary tablespace USERS
CREATE USER "USERNAME" PROFILE "DEFAULT" IDENTIFIED BY "passwd"
DEFAULT
TABLESPACE "USERS" TEMPORARY
TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "USERNAME"; // 可以连接
GRANT "RESOURCE" TO "USERNAME"; //可以创建删除表、视图并可以导入导出
temporary tablespace USERS 临时表空间