１、每个数据库用户帐户都具有以下项目:
（1）唯一的用户名:不能超过30个字节,不能包含特珠字母，而且必须字母开头。
（2）验证方法:口令、外部验证、全局验证
（3）默认表空间:注意创建对象和设置空间限额要另外单独授权。
www.2cto.com
www.2cto.com
（4）临时表空间:用户可在其中创建临时对象(于排序和临时表)的表空间
（5）用户概要文件:分配给用户的一组资源与口令的限制。
（6）使用户组:由资源管理器使用。
（7）锁定状态:用户只能访问"未锁定"帐户。
www.2cto.com
2、创建用户帐户
CREATE USER gyj3
IDENTIFIED BY gyj3
DEFAULT TABLESPACE tp1
QUOTA 10M ON tp1
TEMPORARY TABLESPACE temp
--PROFILE app_user
--PASSWORDEXPIRE
--ACCOUNT LOCK;
建一个最简单的用户操作命令如下：
sys@OCM>CREATE USER gyj3
2 IDENTIFIED BY gyj3
3 DEFAULT TABLESPACE tp1
4 QUOTA 10M ON tp1
5 TEMPORARY TABLESPACE temp;
User created.
3、查询用户信息
sys@OCM>col username for a30
sys@OCM> col default_tablespace for a10
sys@OCM> col temporary_tablespace fora10
sys@OCM> selectusername,default_tablespace,temporary_tablespace,
to_char(created,'yyyy-mm-dd:hh24:mi:ss'),account_statusfrom dba_users;
to_char(created,'yyyy-mm-dd:hh24:mi:ss'),account_statusfrom dba_users;
USERNAME DEFAULT_TA TEMPORARY_TO_CHAR(CREATED,
'YY ACCOUNT_STATUS
------------------------------ -------------------- ------------------- --------------------------
MGMT_VIEW SYSTEM TEMP 2009-08-13:23:24:58 OPEN
SYS SYSTEM TEMP 2009-08-13:23:00:59 OPEN
SYSTEM SYSTEM TEMP 2009-08-13:23:00:59OPEN
DBSNMP SYSAUX TEMP 2009-08-13:23:06:35 OPEN
SYSMAN SYSAUX TEMP 2009-08-13:23:22:32 OPEN
GYJ3 TP1 TEMP 2013-03-01:10:51:33 OPEN
GYJ TP1 TEMP 2013-02-28:15:21:03 OPEN
OUTLN SYSTEM TEMP 2009-08-13:23:01:00 EXPIRED & LOCKED
FLOWS_FILES SYSAUX TEMP 2009-08-13:23:26:08 EXPIRED & LOCKED
MDSYS SYSAUX TEMP 2009-08-13:23:12:05 EXPIRED & LOCKED
ORDSYS SYSAUX TEMP 2009-08-13:23:12:05 EXPIRED & LOCKED
EXFSYS SYSAUX TEMP 2009-08-13:23:09:35 EXPIRED& LOCKED
WMSYS SYSAUX TEMP 2009-08-13:23:07:30 EXPIRED & LOCKED
APPQOSSYS SYSAUX TEMP 2009-08-13:23:06:36 EXPIRED & LOCKED
APEX_030200 SYSAUX TEMP 2009-08-13:23:26:09 EXPIRED & LOCKED
OWBSYS_AUDIT SYSAUX TEMP 2009-08-13:23:35:05 EXPIRED & LOCKED
ORDDATA SYSAUX TEMP 2009-08-13:23:12:05 EXPIRED & LOCKED
CTXSYS SYSAUX TEMP 2009-08-13:23:09:45 EXPIRED & LOCKED
ANONYMOUS SYSAUX TEMP 2009-08-13:23:10:12 EXPIRED & LOCKED
XDB SYSAUX TEMP 2009-08-13:23:10:12 EXPIRED & LOCKED
ORDPLUGINS SYSAUX TEMP 2009-08-13:23:12:05 EXPIRED & LOCKED
OWBSYS SYSAUX TEMP 2009-08-13:23:35:03 EXPIRED & LOCKED
SI_INFORMTN_SCHEMA SYSAUX TEMP 2009-08-13:23:12:05 EXPIRED
& LOCKED
& LOCKED
OLAPSYS SYSAUX TEMP 2009-08-13:23:18:04 EXPIRED & LOCKED
SCOTT USERS TEMP 2009-08-13:23:35:44 EXPIRED & LOCKED
ORACLE_OCM USERS TEMP 2009-08-13:23:02:20 EXPIRED & LOCKED
XS$NULL USERS TEMP 2009-08-13:23:11:44 EXPIRED & LOCKED
BI USERS TEMP 2013-02-27:23:11:56 EXPIRED & LOCKED
PM USERS TEMP 2013-02-27:23:11:56 EXPIRED & LOCKED
MDDATA USERS TEMP 2009-08-13:23:19:11 EXPIRED & LOCKED
IX USERS TEMP 2013-02-27:23:11:56 EXPIRED & LOCKED
SH USERS TEMP 2013-02-27:23:11:56 EXPIRED & LOCKED
DIP USERS TEMP 2009-08-13:23:01:49 EXPIRED & LOCKED
OE USERS TEMP 2013-02-27:23:11:56 EXPIRED & LOCKED
APEX_PUBLIC_USER USERS TEMP 2009-08-13:23:26:09EXPIRED
& LOCKED
& LOCKED
HR USERS TEMP 2013-02-27:23:11:56 EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_USR USERS TEM