Database users to create and modify user information
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]
Related Posts of Database users to create and modify user information
-
Analysis of function
http://hi.baidu.com/jstm_mm/blog/category/% CA% FD% BE% DD% BF% E2% D6% AA% CA% B6 http://blog.sina.com.cn/s/articlelist_1290195934_0_1.html
-
Oracle9i learn step-by-step order (a): create a database manually
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn / as sysdba SQL> conn / as sysdba Is connected to the free routine. SQL> startup nomount ORACLE routines has already started. Total System Global Area 105978600 byt ...
-
Be selected in the Oracle in the relationship between father and son or data record tree
More than we will explain how to find an entry point through a node or nodes of all future generations of ancestors all the nodes, perhaps you will say, I do not need to select all, I am as long as the two-tier election, I am only allowed to show the tree
-
ORA-25153: Temporary Tablespace is Empty
Error: ERROR at line 1: rnORA-25153: Temporary Tablespace is Empty Solutions: Look DBA_TABLESPACES, TEMP's status is also online IXDBA.NET technical community rn SQL> SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES; rn TABLESPACE_NAME STAT ...
-
Profiles Used in Form Personalization
The profile controlling this follows 1 Utilities: Diagnostics = Yes / No This profile option controls whether users can use the examine utility. 2 Hide Diagnostics Menu entry = Yes / No This profile option controls the availability of Diagnostics uti ...
-
Recorded warning DBA: DBA needs to develop some habits
The past few days, a friend in helping to restore data. Caused by failure of reason is very simple to maintain a connection error when upgrading to the production host, resulting in the production database fails, the data files are deleted and partia ...
-
solaris10 oracle10G EM config
solaris10 oracle10G EM config su - oracle emctl status dbconsole (see conditions) su - oracle emctl start dbconsole (Open Service) su - oracle emctl stop dbconsole su - oracle emca-config dbcontrol db-repos recreate (re-configuration management oracl ...
-
The third part (21) Advanced Configuration of the single-source multi-directional replication environment (3)
Fifth, the entire configuration manually copy the environment How do I remove a replication environment, you must have been cooked can not be cooked, not demonstrated here. Attention in front of auto-configuration has also created a number of other schema
-
ORACLE table space-related operations
sqlplus / nolog connect / as sysdba startup sqlplus / nolog connect / as sysdba SHUTDOWN IMMEDIATE If you want to use windows default date format. English is not in the configuration variables in the environment: NLS_LANG american_america.us7ASCII - ...
-
Manually create database command
spool dbcreate.log; CREATE DATABASE "bbk" MAXDATAFILES 500 MAXINSTANCES 8 MAXLOGFILES 32 CHARACTER SET "UTF8" NATIONAL CHARACTER SET AL16UTF16 ARCHIVELOG DATAFILE '/ u01/oradata/bbk/system01.dbf' size 300M EXTENT MANAGEMEN ...
Leave a Reply