==========创建表空间===========
CREATE TABLESPACE DATA01 DATAFILE
'/home/oracle/oradata/orcl/data01.dbf' SIZE 1024M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
(说明:DATA01为表空间的名称,/home/oracle/oradata/orcl/data01.dbf为表空间文件,1024M为表空间大小 )
===============创建用户============
CREATE USER cmmbIDENTIFIED BY cmmb123
PROFILE DEFAULT
DEFAULT TABLESPACE DATA01
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
(说明:cmmb和cmmb123分别为数据库用户名和密码 )
---------赋予权限------------
grant connect,resource,dba to cmmb;
=========修改密码===========
1.查询用户名密码:
select username,password from dba_users;
2.修改用户密码:
alter user portal identified by portal_123;