oracle创建用户

全部选项

CREATE USER username IDENTIFIED BY password 

OR IDENTIFIED EXETERNALLY 

OR IDENTIFIED GLOBALLY AS ‘CN=user' 

[DEFAULT TABLESPACE tablespace] 

[TEMPORARY TABLESPACE temptablespace] 

[QUOTA [integer K[M] ] [UNLIMITED] ] ON tablespace 

[,QUOTA [integer K[M] ] [UNLIMITED] ] ON tablespace 

[PROFILES profile_name] 

[PASSWORD EXPIRE] 

[ACCOUNT LOCK or ACCOUNT UNLOCK] 

基本的连接

grant connect,resource to user;  

grant create session to user;  

例子：

CREATE USER odsc_iocent IDENTIFIED BY ods_c123 
DEFAULT TABLESPACE DATA_CENT TEMPORARY TABLESPACE TEMP 
QUOTA UNLIMITED ON DATA_CENT 
ACCOUNT UNLOCK;
--注意不要给临时表空间QUOTA UNLIMITED不然会报错

基本的连接
grant connect,resource to odsc_iocent;  
grant create session to odsc_iocent