创建用户

create user username
identified by username
default tablespace tablespace_name;

授予一般权限

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 username;

授予DBA权限

grant select on sys.v_$process to username;
grant select on sys.v_$parameter to username;
grant execute on dbms_lock to username;
grant select on sys.v_$lock to username;
grant select on sys.v_$session to username;
grant select on sys.v_$mystat to username;
grant select on sys.v_$session_wait to username;
grant select on dba_kgllock to username;
grant select on sys.v_$sqltext to username;
grant select on sys.slog$ to username;
grant alter session to username;
grant select on dba_undo_extents to username;
grant select on dba_tablespaces to username;
grant select on dba_free_space to username;
grant select on dba_data_files to username;