创建数据库用户及修改用户信息

1.

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]

 

创建用户wang，密码wbtest，默认表空间users,临时表空间temp

create user wang identified by wbtest

default tablespace users

temporary tablespace temp

quota 0 on system-----------配置磁盘限额，此处是不允许用户使用system表空间

 

;

create user wang identified by wbtest

default tablespace users

temporary tablespace temp

quota unlimited on users-----------配置磁盘限额，此处是用户在users表空间不受限制

 

;

2.修改

alter 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]

[default role role[,role]]

  or [default role all [except role[,role]]]

  or [default role note]