首页 > 代码库 > 创建用户

创建用户

只有dba权限的用户才可以创建用户:

create user username

identified {by password|EXTERNALLY|GLOBALLY AS external name}

[default tablespace tablespace_name]

[temporary tablespace tablespace_name]

[quota{正整数 [K|M]} on tablespace_name]

[quota{正整数[K|M]} on tablespace_name]

[password expire]

[account{lock|unlock}]

[profile{概要文件|default}]

创建用户