/*1、创建临时表空间 */
create temporary tablespace ecm_temp
tempfile 'D:\oracledata\ecm_temp .dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
/*2、创建数据表空间 */
create tablespace ecm_data
logging
datafile 'D:\oracledata\ecm_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
/*3、创建用户并指定表空间 */
create user ECM identified by ECM
default tablespace ecm_data
temporary tablespace ecm_temp ;
/*4、授权用户并指定用户永不过期 */
create user sunflow identified by sunflow ;--新建
grant connect,resource to sunflow ;--授权用户
grant select any table to sunflow ;
grant delete any table to sunflow ;
grant update any table to sunflow ;
grant insert any table to sunflow ;
grant alter any table to sunflow ;
--alter user sunflow account UNLOCK;--解锁用户帐号
alter profile default limit failed_login_attempts unlimited;--密码有效期由默认的180天修改成“无限制”
/*4、修改用户密码 */
alter user 用户名 identified by "密码";--修改密码