Database users to create and modify user information

Posted on 2009-06-23 filed under: Oracle (RSS) 17 views

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]

Create user wang, password wbtest, the default tablespace users, temporary tablespace temp

create user wang identified by wbtest

default tablespace users

temporary tablespace temp

quota 0 on system ----------- configure disk quota is not allowed here to use system tablespace

;

create user wang identified by wbtest

default tablespace users

temporary tablespace temp

quota unlimited on users ----------- configure disk quota, here is the user space restrictions in the users table

;

2. Modify

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]