创建用户

create tablespace w
datafile
'/dev/rportalone_data'
size 30000m
extent management local
segment space management auto
/

create tablespace ww
datafile
'/dev/rportalone_idx'
size 10000m
extent management local
segment space management auto

/
------------------------------------
-- 以下操作在sys用户下执行 --
------------------------------------

create user wcy
identified by wcy
default tablespace portalone
temporary tablespace temp
/

grant connect,resource,create any table,drop any table,create sequence,
select any table, create any index, drop any index,
alter any trigger, create any trigger, drop any trigger,
alter any type, create any type, drop any type,
create any view, drop any view, create any directory,
create procedure, query rewrite, create session to wcy
/

grant select on v_$process to wcy
/

grant select on v_$parameter to wcy
/

grant execute on dbms_lock to wcy
/

grant select on v_$lock to wcy
/

grant select on sys.v_$session to wcy
/

grant select on sys.v_$mystat to wcy
/

grant select on sys.v_$session_wait to wcy
/

grant select on dba_kgllock to wcy
/

grant select on sys.v_$sqltext to wcy
/

grant select on sys.slog$ to wcy
/

grant alter session to wcy
/

grant alter system to wcy
/