介绍典型的语法
- create user userName
- identified by passWord
- default tablespace tablespaceName
- temporary tablespace tablespaceName
- profile profile
- quota integer|unlimited on tablespaceName
各选项含义如下:
IDENTIFIED BY password:用户口令;
DEFAULT TABLESPACE tablespace:默认表空间;
TEMPORARY TABLESPACE tablespace:临时表空间;
PROFILE profile|DEFAULT:用户资源文件;
QUOTA integer[K|M]|UNLIMITED ON tablespace:用户在表空间上的空间使用限额,可以指定多个表空间的限额。
举例:
CREATE USER us1 IDENTITIED BY abc123
DEFAULT TABLESPACE SAMPLE1
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
QUOTA 1000M ON SAMPLE1;