创建用户

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
/