SQLPLUS
环境下
①
用户及用户下面所有表的删除
drop user
username
cascade;
②
创建用户
create user
username
identified by
password
;
修改密码
alter user system identified by [password]
alter user system identified by [password]
③
分配表空间
alter user
username
default tablespace
表领空间
quota unlimited on
表领空间
;
创建表空间
CREATE TABLESPACE "ts"
LOGGING
DATAFILE 'E:/ORACLE/ORADATA/TEST/ts.ora' SIZE 50M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
LOGGING
DATAFILE 'E:/ORACLE/ORADATA/TEST/ts.ora' SIZE 50M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
④
权限赋予
grant
create session
to
username
;
(create session
:连接数据库的权限
)