kods.net » temporary tablespace,user information,cn » Database users to create and modify user information

Database users to create and modify user information

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]
Digg Technorati StumbleUpon Mixx del.icio.us Reddit BlinkList Furl YahooMyWeb

Tags: temporary tablespace, user information, cn, disk quota, space restrictions, database users, profile name, profiles

Permalink: http://www.kods.netwww.kods.net/database-users-to-create-and-modify-user-information/

Leave a reply