sqlplus中: CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]for example:
create user username identified by password default tablespace spacename1 temporary tablespace spacename2;
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]for example:
create user username identified by password default tablespace spacename1 temporary tablespace spacename2;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货